0 Replies Latest reply: Mar 26, 2015 10:13 AM by Steve Moyal RSS

    Qlik-Essbase connector hierarchy to display alias and member name

      Per the Qlik Essbase Connector 1.0 release notes: 'If a dimension has an alias, both the alias and dimension name are displayed in a hierarchy. If there is no alias, only the name is displayed.'  We have aliases maintained for our Custom 1,2,3 and 4 hierarchies in our Essbase application, however the connector is currently only displaying the member name.  Please advise if there are any settings or modifications to the script to include the alias in the hierarchy (below is a sample of the script generated to extract our Custom 2 / TA dimension, which is currently only displaying the member name):

       

      [TA]:

      HIERARCHY([TA_Key], [TA_Parent_Key], [TA_Desc], [TA Parent Name], [TA_Desc], [Hierarchy TA], '/', 'TA Hierarchy depth')

      LOAD [TA_Key], [TA_Parent_Key], [TA_Desc];

      SELECT [TA] FROM SHIRE.ALL;


      [TA2]:

      HierarchyBelongsTo([TA_HKey], [TA_Parent_Key], [TA_Desc], 'TA_Ancestors_Key', 'TA_Ancestors_Name', 'TA_Depth')

      LOAD [TA_Key] as [TA_HKey], [TA_Parent_Key], [TA_Desc];

      SELECT [TA] FROM SHIRE.ALL;


      [Rel_TA]:

      LOAD [TA_Ancestors_Key] as [TA_Key],

           [TA_HKey] as [TA.Levels(8)]

      RESIDENT [TA2];

       

      DROP TABLE [TA2];

       

      Thank you for any assistance you can provide.