Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Javier
780
Can´t access to the second database
posted

I have a Analysis Services 2008 with two Databases and different Cubes. When I try to access with XamPivotGrid always see the first in sequence Alphabetical Database.

I have defined the DataSource in XAML or by code and in no of both cases it accedes to the indicated database. If I change manually in the Selector the data are transferred correctly to the XamPivotGrid.

 

 

 

 

 

 

 

 

 

 

 

 

 

Dim dataSource As New XmlaDataSource

()

 

 

 

dataSource.ServerUri =

 

 

New Uri("http://**********/olap/msmdpump.dll"

)

dataSource.Credentials =

 

 

New XmlaNetworkCredential

(wrkUsuario, wrkPass, wrkDominio)

dataSource.Database =

 

 

XmlaDataSource.GenerateInitialDatabase("FSGA_BI_Project"

)

dataSource.Cube =

 

 

XmlaDataSource.GenerateInitialCube("FSGA"

)

 

 

 

dataSource.Rows =

 

 

XmlaDataSource.GenerateInitialItems("[Usuario].[Usuario]"

)

dataSource.Measures =

 

 

XmlaDataSource.GenerateInitialItems("Horas"

)

dataSource.Columns =

 

 

XmlaDataSource.GenerateInitialItems("[Clientes].[Cliente]"

)

dataSource.Filters =

 

 

XmlaDataSource.GenerateInitialItems("[Usuario].[Area],[Fecha Actividad].[Estr Fecha Actividad]"

)

_-----------------------------------------------------------------------------------------

<igXmla:XmlaDataSource

x:Key="DataSource"

ServerUri="http://***********/olap/msmdpump.dll"

Database="FSGA_BI_Project"

Cube= "FSGA"

Filters="[Usuario].[Area],[Fecha Actividad].[Estr Fecha Actividad]"

Rows="[Usuario].[Usuario]"

Columns="[Clientes].[Cliente]"

Measures="Horas">

<igXmla:XmlaDataSource.Credentials>

<igXmla:XmlaNetworkCredential Password="*************"

UserName="gpu" Domain="FULLSTEP">

</igXmla:XmlaNetworkCredential>

</igXmla:XmlaDataSource.Credentials>

</igXmla:XmlaDataSource>

 

 

 

Can you help me?