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
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