Skip to main content
M
miked
Contributor
August 22, 2022
Solved

Metadata Report

  • August 22, 2022
  • 3 replies
  • 0 views

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

Best answer by tdugas

Yes that is correct

 

ud8.PNG

3 replies

N
NidhiMangtani
Veteran
August 22, 2022

Hello,

You can use XFMemberProperty syntax mentioned below to retrieve details in your report:

XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Text2)

Hope this helps.

    T
    tdugas
    Member
    August 25, 2022

     

     

     

    I am attaching two screen shots of our meta data dashboard  hope that helps

     

    metadatadashboard.PNG

     

    metadatadashboard2.PNG

    M
    mikedAuthor
    Contributor
    August 25, 2022

    ok so you set each member property up as a dimension member in UD8 i am presuming?

    T
    tdugas
    Member
    August 25, 2022

    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

    T
    tdugasAnswer
    Member
    August 25, 2022

    Yes that is correct

     

    ud8.PNG

    M
    mikedAuthor
    Contributor
    August 25, 2022

    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.

      Terms & ConditionsAccessibility statement