08-22-2022 09:39 AM - last edited on 05-24-2023 04:53 AM by JackLacava
Hi All,
Does anyone know of nice reporting on the metadata and the properties of each member? Basically, I am looking for something like the Dimension Library Grid View to be displayed in a user-friendly report. Before we start building something I wanted to make sure someone doesn't have an easy solution for this. Would want something that users could easily access perhaps via Cubeview or Dashboard content.
An example would be a report that shows all of the accounts with their metadata properties (ie. description, AllowInput, AcctType, Text1-8, etc.). I checked the Application Reports (RPTA) that is in MarketPlace but it doesn't have anything.
Thx,
Mike
Solved! Go to Solution.
08-25-2022 01:37 PM
08-22-2022 10:33 AM - edited 08-22-2022 10:39 AM
Hello,
You can use XFMemberProperty syntax mentioned below to retrieve details in your report:
XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Text2)
Hope this helps.
08-25-2022 10:56 AM
I am attaching two screen shots of our meta data dashboard hope that helps
08-25-2022 12:01 PM
ok so you set each member property up as a dimension member in UD8 i am presuming?
08-25-2022 01:48 PM
If you want the extract xml of that dimension, post your email and I can send to you, it wont let me post that much data here
08-25-2022 01:37 PM
Yes that is correct
08-25-2022 01:59 PM
ok thx...we have similar members setup so I think I am okay. Was hoping there was a way to do without having to add members to dimension. Thx for your help on this.