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?

 

 

 

CUBE:

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

    </DimensionUsage>

 

 

GLOBAL DIMENSION:

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

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

      <Table name="DIM_EMPLOYEE">

      </Table>

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

      </Level>

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

      </Level>

    </Hierarchy>

  </Dimension>

Outcomes