Forum Discussion
Limiting date range import from SSAS Cube
Hello, I am running into an issue when attempting to import dates from our SSAS cubes. In order to create the report that I want, we have to use fields that have a large number of distinct value...
Hi bosleyjarrett,
According to my test, we can truncate the query in the Query Editor. For example, I have table with 10 thousands rows. I edit it in the Query Editor to keep only top 200 rows. Then the loading is very fast due to there are only 200 rows.
If you want to filter them by MDX, you should do it in the initial interface.
Best Regards!
Dale
My issue is getting the data into the query editor view. The dataset is very larger and is unable to load into the editor.
Hi bosleyjarrett,
Maybe you can try to get data in Query Editor. The dataset only has preview in Query Editor. You can manipulate it before applying in the Query Editor where you can reduce the size of dataset.
Best Regards!
Dale