Analytic model in Power BI

[Venky999]

Hi,

Can we consume Analytic model in Power BI?

If yes, please let me know what type of connection to choose (ODATA or ODBC)

Thank you

[XaviPolo]

You can consume Analytic Models from PBI with ODBC (HANA DB access)

You will see the AM as a SQL View with the technical name of the AM.

Remember that if the AM has Input Variables, you can fill them with PLACEHOLDER and the techname of the parameter like in:

SELECT * FROM AM_SALES (
  PLACEHOLDER."$$DATE_FROM$$" => '2023-01-01',
  PLACEHOLDER."$$DATE_TO$$" => '2023-01-31'
);

Regards,

[Venky999]

Hi Xavier,

Do you mean column view ?

I do not see a view generated in the HANA DB (Under the views in Catalog), I could see only column view generated in the DB.

[XaviPolo]

I'm using DBeaver to connecto to DSP HANA DB, like many other DB clients it doesn't differentiate between column or regular views, just Tables, Views etc.

When I look at Views section I can see all Analytic Models (in my case all of them start with AM_).

Regards,