How to connect to cube using username and password?

[Yohan]

I am using the PivotGrid to connect to the cube. But unless I give permission to Everyone, I can’t connect to the cube using the domain account I have.

 

Here is how I set it up:

 

<OlapSettings ProviderType="Adomd">

    <AdomdConnectionSettings Cube="FCube"

                             DataBase="FirstCube"

                             ConnectionString="Data Source=XXX;Catalog=FirstCube;User Id=xxx\xxx;password=xxxx;">

     </AdomdConnectionSettings>                  

</OlapSettings>

 

Please let me know what I should do.

[Maria Ilieva]

Hello Yohan,

Please review the answer provided in the support ticket you have opened for the same issue.

Regards,
Maria Ilieva
Telerik

[Dick Arlbring]

I would love to see that support ticket too, I have the same problem. 

[Pavlina]

Hello Dick,

Below you can see the answer provided in the mentioned support ticket:

Thank you for contacting us.

The problem you are facing is actually not directly related with the RadPivotGrid control but is mostly generic connectivity issue. I would suggest you to review the resources below which may help in this case:

http://support.microsoft.com/kb/236315
http://kb.jetreports.com/article/AA-00752/0/

I hope this helps.

Regards,
Maria Ilieva
Telerik


Regards,
Pavlina
Telerik

 

 

[Dick Arlbring]

Hello Pavlina.

I am able to use the identical connectionString in other connections and it's working.
When I am the PivotGrid I am getting a error msg in RadPivotGrid1.DataProviderError:

Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Unable to recognize the requested restriction 'CUBE_SOURCE'.

Do you have any idea about why this error occurs?

[Pavlina]

Hi Dick,

It appears that this is a permission issue with your SQL Server instance and as pointed in the previous reply this is not related to the pivotgrid control. You can check the user credentials in your connection string as the issue may be there.

Regards,
Pavlina
Telerik

 

 

[Dick Arlbring]

Hello Pavlina!

Like I said, I am using the same connectionString elsewhere. Not with the telerik:RadPivotGrid only using it by creating a AdomdConnection from Microsoft.AnalysisServices.AdomdClient.dll (Copy local=true).
It leads me to believe that the PivotGrid is somehow creating the error message.

When I am using the identity on my Application pool it's working but I need to be able to change connectionuser. That's why I want to send User id and password in the connectionString not setting a identity on the Application Pool.

The database is using Role-based security settings.

This is the whole error message:
Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Unable to recognize the requested restriction 'CUBE_SOURCE'. at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IDiscoverProvider.Discover(String requestType, IDictionary restrictions, DataTable table) at Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.Discover(AdomdConnection connection, String requestType, ListDictionary restrictions, DataTable destinationTable, Boolean doCreate) at Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.PopulateSelf() at Microsoft.AnalysisServices.AdomdClient.ObjectMetadataCache.Microsoft.AnalysisServices.AdomdClient.IObjectCache.Populate() at Microsoft.AnalysisServices.AdomdClient.CacheBasedNotFilteredCollection.PopulateCollection() at Microsoft.AnalysisServices.AdomdClient.CacheBasedNotFilteredCollection.get_Count() at Microsoft.AnalysisServices.AdomdClient.CubesEnumerator.MoveNext() at Microsoft.AnalysisServices.AdomdClient.CubeCollection.Enumerator.MoveNext() at Telerik.Web.UI.PivotGrid.DataProviders.Adomd.AdomdMetadataLoader.PrepareMetadata(AdomdConnection cubeConnection, OlapCatalogInfo catalogInfo) at Telerik.Web.UI.PivotGrid.DataProviders.Adomd.AdomdMetadataLoader.ConnectAndGetMetadata() at Telerik.Web.UI.PivotGrid.DataProviders.Adomd.AdomdMetadataLoader.LoadData()

[Maria Ilieva]

Hi Dick,

Could you please post your PivotGrid markup with the OLAP settings so that we could further research on your case?
Also I would suggest you to update your application to use the latest internal build of our controls as we have made some optimizations in the OLAP binding mechanism which might give affect in your case.

Regards,
Maria Ilieva
Telerik

 

 

[Dick Arlbring]

Hello Maria!

This is how my PivotGrid: 

<telerik:RadPivotGrid AllowFiltering="true" ID="RadPivotGrid1"
    RowTableLayout="Tabular" FieldsPopupSettings-AggregateFieldsMinCount="1" AllowPaging="true"
    PageSize="20" runat="server" EnableConfigurationPanel="true" EnableZoneContextMenu="true"
    AggregatesPosition="Rows" OnCellDataBound="RadPivotGrid1_CellDataBound"
    OnPivotGridBiffExporting="RadPivotGrid1_PivotGridBiffExporting"
    OnPivotGridCellExporting="RadPivotGrid1_PivotGridCellExporting">
    <FieldsPopupSettings AggregateFieldsMinCount="1"></FieldsPopupSettings>
    <PagerStyle AlwaysVisible="False" />
    <OlapSettings ProviderType="Adomd">
        <AdomdConnectionSettings
            Cube="CubeName"
            DataBase="DatabaseName"
            ConnectionString="Provider=MSOLAP.4;Data Source= Ip;Initial Catalog=CatalogName;User Id=DOMAIN\\User;password=Password;"></AdomdConnectionSettings>
    </OlapSettings>
    <ConfigurationPanelSettings Position="Top" LayoutType="Stacked" DefaultDeferedLayoutUpdate="false" />
    <ClientSettings>
        <Scrolling AllowVerticalScroll="true" ScrollHeight="600px" />
    </ClientSettings>
</telerik:RadPivotGrid>

I am going to try the latest internal build, I will let you know if it solved the problem. 

Please let me know if you need anything more. 

Regards

[Dick Arlbring]

Hello!

I have now tried using the the latest internal build, but with no luck. I am still getting the same error message as before. 

[Maria Ilieva]

Hello Dick,

The connection string based on the Microsoft's best practices in this case should be set in the following format:

Data Source=https://<;servername>/olap/msmdpump.dll; Initial Catalog=AdventureWorksDW2012; Integrated Security=Basic; User ID=XXXX; Password=XXXXX;

 which is different than the one you are using.

Please review the topic below and ensure that you are following the provided instructions for configuring the cube and setting its connections.

http://msdn.microsoft.com/en-us/library/gg492140.aspx

Regards,
Maria Ilieva
Telerik