Forum Discussion
Limiting date range import from SSAS Cube
These are multi-dimentional cubes and we are importing rather than live querying.
Do I have to use a different MDX syntax than what I would use in an excel instance of SSAS? We have multiple cubes on this server and it seems like it does not know where to execute the query.
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
