FdxExecuteCubeView Function
What is the purpose of timeMemFilter, entityMemFilter and scenarioMemFilter parameters for the below function as these will be defined in the cube view?
Is there a way to extract aggregated membe...
Forum Discussion
As for aggregating, it would be very inefficient to have a cube view that shows all the base-level details for every Account/Flow/IC/UD1-8 and then aggregate it in the FDX / Business rule into a more summarized version. You could do this by using a Dictionary object (by AccountId, Amount ) and then simply aggregating the Data Rows returned from the FDX query into a Dictionary object. Then you would have a simple list of totals by just Account. Or you could use a ValueTuple object if you wanted to combine multiple columns into one key. But I may be misunderstanding the question here since I wouldn't recommend aggregating the results of an FDX query.
Chris
I don't want to use a cube view for base level data or aggregate the results of an FDX query. My question was, is there a possibility to extract 'aggregated' data (Account and UD1 to UD8). The only way I found out was to use a cube view to define members at a higher level and then use an FDX query to extract. However, I can't use all the dimensions in a cube view right?
Anyways we have now set up to extract base data and dimension hierarchies via API calls and feed it to our Power BI models.
Thanks again for your inputs.
Best
Sai
Hi Sai_Maganti
Do you have an example code to extract data to the SQL table using FDX queries ?Thank you
Sridhar
