Hello Ankit,

I have checked in our internal system and there seems to be no known performance issues related to the loading time of the FlatDataSource.

Please share a sample which illustrates the scenario on your side so I can investigate this further for you.

Please let me know the specific version you are testing with (including the build number e.g. 16.2.2045).

Thank you.

Hi Maria 

We are using FlatDataSource as our datasource to populate the data on OLAP cube. 

Can this be an issue for the time consumption..

Hello Ankit,

Please elaborate on the results you are seeing.

1. Have you tested with the latest Service Release – 2016.2.2045? Is the loading time the same?
2. It took about 100 seconds to load using the XamPivotDataSelector. How much time does it takes to load in Excel?
3. Have you tried isolating the application a bit and loading the XamPivotDataSelector without XamTabControl to make sure loading the tab and other controls does not interfere with the loading time? 

Hi Maria

It almost take near about 100 seconds to load the same.

Hello Ankit,

There are a couple of things that you might want to try. First you can try to isolate the behavior in a scenario without the XamTabControl to check if the loading is still slow.

Another thing is that if you are loading data from a server it might need significant amount of time to access the data so you could load it in Excel and check if the time is approximately the same.

How much time does it takes to load the data in the XamPivotDataSelector in your project? You can test with our latest Service Release 16.2.2045 to check if the loading takes less time.