AnsweredAssumed Answered

reuse mondrian dimension with different caption

Question asked by Sebastian Schenk on Feb 5, 2019

How can I reuse the dimension e.g. employee

     with different captions: as broker, employee, advisor

but with the

     same structure: Name+Employeeno


Example implementation below explained:

I want that caption="%{source_employee}" is no longer declared in the global dimension, it should be given in the DimensionUsage for the hierarchy as well as for the level caption. I want to completely rename the global dimension and not give a prefix or suffix. Do you know any tutorials on this?





    <DimensionUsage source="employee" name="employee" visible="true" foreignKey="EMPLOYEE_ID" highCardinality="false">





<Dimension type="StandardDimension" visible="true" highCardinality="false" name="source_employee" caption="%{source_employee}">

    <Hierarchy visible="true" hasAll="true" primaryKey="ID">

      <Table name="DIM_EMPLOYEE">


      <Level name="employee" visible="true" column="EMPLOYEENO" ordinalColumn="NAME" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" caption="%{source_employee}" captionColumn="NAME">


      <Level name="employeeno" visible="true" column="EMPLOYEENO" type="String" internalType="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" caption="%{employeeno}">