Hello,
Connecting the XamPivotGrid/XamPivotDataSelector to an ssas server in tab mode, i can see my Measures/Hierarchies, but no Levels beneath the Hierarchies.
Connecting to the same server with Excel works like a charm. Doesn't the xamPivotGrid support Tabularmode?
BR,
Daniel Clausen
Hi Daniel,
I'm looking into this for you. Currently I'm putting together a sample with an SSAS server in tabular mode. I'll update you again when my sample is ready.
It's taking me a bit longer than expected to get an instance of Analysis Services in Tabular Mode setup. Just wanted to let you know that I'm still looking into this for you.
Sorry for the delay. I ran into issues getting the database setup with AdventureWorks. I finally got it to a point where I could test this and when I checked the hierarchies in the XamPivotDataSelector I was able to see the levels below them. How are you connecting to your database? What is the connection string you are using? Can you send me the XAML/Code?
Hello Jeferson,
As Rob mentioned we have logged this behavior with our engineering staff to look into the issue further. I have created a private case for you to track progress of this issue. Your case number is CAS-119135-L1H5T8. I will be contacting you thru this case in regards to this issue.
Sincerely,
Valerie
Developer Support Engineer
Infragistics
www.infragistics.com/support
Dear sir,
I have the same problem appointed by Daniel.
I created a tabular cube instance and I'd like to know if this issue (CAS-115581-L7S3S1) was solved and how can I solved this problem.
I have a urgent project to deliver and this solution is very important to me.
Best regards,
Jeferson Rodrigues
Brazil, Sao Paulo - SP
=========================================
Daniel, caso tenha acesso à essa solicitação eu gostaria muito de saber se resolveu esta questão e qual o caminho encontrado para solucioná-la.
Seu contato seria muito bem vindo!
Atenciosamente.
(011) 99119-2855
jeferson.rodrigues@linx.com.br
If the data shows up properly in excel I would expect that it functions the same way in the xamPivotGrid. It's not a requirement to have an "All" node in the hierarchy.
Initially I thought you were referring to the hierarchies in the data selector not showing up but as I tested the issue more I found that when I dragged a dimension to the row or column section that the rows did not fill in and I was presenter with a screen similar to your initial screenshot where you have "ArabicDescription" in the columns section but there are no columns appearing.
I have asked our engineering staff to examine this further. To ensure that it will receive attention, I have logged this behavior in our internal tracking system with a Development ID of 144176. The next step will be for a developer to review my investigation and confirm my findings or to offer a fix, or other resolution.
I have also created a private case for you on this issue (CAS-115581-L7S3S1) that has been attached to the development issue. You can view the status of the development issue connected to this case by selecting the "Development Issues" tab when viewing this case on the web site.
Please let me know if you need more information.
Hi Rob,
I just discovered what i think might be the cause of my problem: The "all"-Node is missing
Does the XamPivotGrid/XamPivotDataSelector need the "All"-Node to work properly?
BR
Sorry for the delay!
I Connect to the DataBase via an AdomdDataSource, the code for connecting is as follows:
var result = new AdomdDataSource();
try{var settings = new AdomdConnectionSettings{ConnectionString =string.Format(@"Provider=MSOLAP.3; Data Source={0}; user id ={2}; password={3}; catalog={1};",server, database, usr, pwd)};
result.ConnectionSettings = settings;result.Database = XmlaDataSource.GenerateInitialDatabase(database);result.Cube = DataSourceBase.GenerateInitialCube(cube);result.Initialized += DataSourceInitialized;result.RefreshGrid();}catch (Exception ex){//something}
return result;
###############
Xaml:
<igPivot:XamPivotGrid Grid.Column="0" x:Name="pivotGrid" DataSource="{Binding DataSource}" EnableAdvancedFiltering="{Binding EnableAdvancedFiltering}" AllowCompactLayout="True" /> <GridSplitter Grid.Column="1" IsEnabled="True" /> <igPivot:Expander Grid.Column="2" IsExpanded="False" x:Name="Expander"> <igPivot:XamPivotDataSelector x:Name="dataSelector" MaxWidth="250" DataSource="{Binding DataSource}"/> </igPivot:Expander>
######################################
As You can see, the XamPivotGrid as well as the XamPivotDataSelector are connected to the DataSource (Property of type DataSourceBase) that my ViewModel exposes. When Connecting to a cube, either a XMLADataSource or AdoMDDataSource is created which works well when connecting to the server directly or via XMLA, but not in Tab mode.
Here is a screenshot of how the XamPivotDataSelector looks when connected to a Cube in Tabular Mode: