The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Sai_Maganti's avatar
Sai_Maganti
Contributor II
4 years ago

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...
Admin
ChrisLoran's avatar
ChrisLoran
Icon for OneStream Employee rankOneStream Employee
4 years ago

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.

Sai_Maganti's avatar
Sai_Maganti
Contributor II
4 years ago

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

  • Sridhar_M's avatar
    Sridhar_M
    Contributor
    3 years ago

    Hi Sai_Maganti 
    Do you have an example code to extract data to the SQL table using FDX queries ?

    Thank you

    Sridhar