Supplier Cost Dashboard

[tommat01]

Hello, I'm looking to create a dashboard which visualises our supplier costs and has the ability to compare them to our forecast numbers/previous years (FP, RF0, FY22 etc). All the data would come from Hyperion. Is anyone able to advise how I would start this? Thank you

[v-stephen-msft · Accepted solution]

Hi  @tommat01 ,

To connect to the Hyperion data source in Power BI Desktop, you can follow these steps:

• Open Power BI Desktop and click on "Get Data" from the Home tab.
• Select "Oracle" from the list of available data sources.
• Enter the server name and database name for your Hyperion instance.
• Choose the appropriate authentication method and enter your credentials.
• Select the tables or views that you want to import into Power BI Desktop.
• Click "Load" to import the data into Power BI Desktop.

Or you can consider the link:

https://community.powerbi.com/t5/Desktop/Oracle-Hyperion-Essbase-Essbase-connector/m-p/826346

https://learn.microsoft.com/en-us/power-query/connectors/essbase

If you want to compare data from previous years, you can consider the following formula:

Cureent Year =
SUMX(
    FILTER(ALL('Table'),
    YEAR('Table'[Date])=YEAR(TODAY())),[Value])

FY22 =
SUMX(
    FILTER(ALL('Table'),
    YEAR('Table'[Date])=YEAR(TODAY())-1),[Value])

The first two years =
SUMX(
    FILTER(ALL('Table'),
    YEAR('Table'[Date])=YEAR(TODAY())-2),[Value])

If it doesn't meet your expectations, can you express your results in the form of pictures, we can better help you

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly