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?

[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