Is there a way to query BPC model using SQL?

[mrj_marcelo]

Hi, I would like to now if there is a way to query BPC models by SQL. Currently for that I have activated SAP HANA views for models and they works fine, I can query the models by SQL, but using that resource I can't get values for BPC member formulas or filter directly by hiearchy nodes, I just can get values stored in DB and base members. So thinking to get member formulas values and filter by hierarchy nodes, is there any way to query bpc models using SQL by calculation view or any other way?

[Savio_Dmello]

Member formula results are never stored. As a custom workaround, you can save the result using EPMSavedata. And then you can use the backend table where member formula are stored.

Also check sap note " 3019453 - Which table stores the member fomulas "

 

[William_Yu]

Hi mrj_marcelo, 

  Member formula(and  measure formula) of BPC is calculated via MDX syntax. BPC reporting logic sends either BW MDX or HANA MDX to BW or HANA.  By directly query via SQL won't provide you result of formula. 

Best regards, William