Forum Discussion

Gert_VCC's avatar
Gert_VCC
New Contributor III
5 months ago

Viewing all Metadata and values in Cube View or Spreadsheet

I am attempting to create a view in a dashboard for users to be able to see all metadata for each row with that value. Essentially I need to recreate the "Data Records" Report in the database.  I w...
Cube View
Parameters
Gert_VCC's avatar
Gert_VCC
New Contributor III
5 months ago

Hi VishalPai,

This method does show all metadata but I am struggling to get it to work with expansion functions. For example E#Child1 works but E#Parent1.Base fails to show anything. 

VishalPai's avatar
VishalPai
Contributor
5 months ago

If expansion of Entity needs to be applied, then VDataRecords view needs to be joined with relevant application tables like member and others as you can then pass the entity members as list to that SQL query through XFBR based on parent entity selection by user

Not aware of any readily available solution in OS today