Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Not Planned
Workspace Jedox Platform
Created by Guest
Created on Feb 10, 2023

Ability to directly translate (using Alias) rgrp/fgrp ids using the database dimension from the system database to their real name

If you want to see the Alias of a rgrp/fgrp id, you need to create Integrator extracts of the System database. We would like to directly access these aliases, instead of always running an Integrator job that writes them to one of our cubes.

  • ADMIN RESPONSE
    Feb 10, 2023

    Thanks for the idea. This feature has been evaluated by us and we will not implement at this time.

    These databases are internally used for metadata and not necessarily meant to be exposed in a report. It would help us, if you could elaborate more on the use case. This then might give us an idea, why accessing these databases is required and what else we could improve to eliminate the need for this.

    If it's about easier managing access rights to published reports, feel free to vote for and comment on this related idea.



  • Guest
    Reply
    |
    Nov 3, 2023

    This alias can easily be retrieved from the attribute "data" of the element "group" in the dimension "meta" of the corresponding database.

    e.g.: PALO.DATA("localhost/fgrp1","#_meta","data","group")

    <element name="fgrp1" type="file"> <info> <name>Default</name> <desc>Default resource group</desc> <comment></comment> <i18n/> </info></element>


    With an appropriate business rule it is straight forward to see this aliases whereever you want.