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

Martin_Gebhartl's avatar
Martin_Gebhartl
Contributor
1 year ago

Dimensions Descriptions via PowerBI connector

Hi,

does anyone know how to get the dimension descriptions (other then default) into PowerBI via the OneStream PowerBI Connector?

In the OneStream PowerBI Connector, there is the "Get Dimension" part with an "include descriptions" option but it only loads the default description (which is english in our setup). We have also a German culture setting and all descriptions are setup in English and German but I cannot find a possibility to get the German descriptions in PowerBI.

Regards
Martin

 

Reports

1 Reply

  • Martin_Gebhartl's avatar
    Martin_Gebhartl
    Contributor
    1 year ago

    I was able to find a solution. I built a custom data adapter with an SQL rule, which joins the information of the member table with the member description table. This data adapter can be used in the PowerBI connector to get this information into PowerBI.

    Regards
    Martin