This function retrieves data from a OneStream Cube. Populate the data unit dimensions:
-
Scenario
-
Time
-
Entity
-
View
-
Currency/Consolidation
NOTE: Expansion members can be used for all inputs except View and Currency/Consolidation which require a single member. For example, the time dimension could use 2023.Base.
Video Use Case Series
This video series demonstrates how to connect to your OneStream data using Get Cube Data in Power BI.
-
Background: Connecting data using the Get Cube Data adapter and then transforming the data to restructure how the data is pulled. The data query is transformed further in each subsequent video to accommodate variable month reporting and entity and cube dimensionality.
-
Role: Users of the OneStreamPower BI Connector.
-
Benefits: Understand how OneStream data is pulled, transformed, and enhanced using Power BI.
| Title | Description | Link |
|---|---|---|
| Connecting to OneStream Using Cube Data | Connect to OneStream and pull data leveraging the Cube Data adapter method | |
| Using the Get Cube Data and Transforming the Data | Modifying a OneStream Get Cube Data Query and Transforming the data to restructure how the data is pulled. | |
| Expanding the Use Case for a Variable Month | Transforming a OneStream query to accommodate variable month reporting (Forecast vs Actual). | |
| Expanding the Use Case to the Entity and Cube Dimensions | Transforming a OneStream query to accommodate variable entity and cube dimensionality. | |
| Expanding the Use Case Further | Transforming the OneStream query to only update Actual reporting periods for the most recent reporting periods. |
Watch a tour (2:56).
