Planning Analytics with Watson

Expand all | Collapse all

Cubes & Dimensions aliases

  • 1.  Cubes & Dimensions aliases

    Posted Tue June 29, 2021 03:30 AM
    Hello Community,
    Following what's written in the documentation, I succeeded in creating aliases for cubes & dimensions and in order to use it in PASS or PAW, I do understand that you have to change my internet browser default language.
    I was wondering if there was not another option to activate it, just like for dimension members aliases where you can change the alias table used on the fly without any Internet browser configuration.
    My use case is linked to the fact that we're defining corporate cubes & dimensions and deploying them over a set of business specific databases in which these corporate objects could have a slightly different name.
    Thanks for your help.
    Regards,

    ------------------------------
    Bob
    ------------------------------


  • 2.  RE: Cubes & Dimensions aliases

    Posted Tue June 29, 2021 02:45 PM
    Hi Bob,
    You could create captions for your cubes and dimensions for the same language - exactly as you explained, just to display to the group of the users slightly different names for the objects in the same language. Here I have a screenshot where the name of the cubes being displayed in the tree is not the original cube names. You could go through the Control Object cube }CubeCaptions and enter your different cube name for the same language there.  If this control cube is not available, you may try to run the TI process to create it aprx as following: CubeAttrInsert( '', 'Caption', 'A');
    CubeAttrPutS( 'New Name for users', 'JohnOCube', 'Caption', 'en' ); Note that the other control cubes with }Caption dimension (i.e }LocalizedCubeAttributes would get this value as well. Hope this helps.
    Best Regards,
    Svetlana


    ------------------------------
    Svetlana Pestsova
    ------------------------------



  • 3.  RE: Cubes & Dimensions aliases

    Posted Wed June 30, 2021 04:04 AM
    Edited by Robert MILLI Wed June 30, 2021 04:17 AM
    Hello Sveltana,
    First let me thank you for your answer, it opens my mind in order to propose better solution to my user community.
    I've tried your solution and it almost fits all my needs but it shows up slightly differently than what you were talking about.
    The system cubes created with the CubeAttrInsert( '', 'Caption', 'A'); and DimensionAttrInsert('', 'Caption', 'A'); TI commands are called }CubeAttributes and }DimensionAttributes and not }CubeCaption & }DimensionCaption . These cubes only get 2 dimensions }Cubes  & }CubeAttributes.
    This being said, there no place in the user interface to switch on the fly from one caption to another, once you've entered a value for a Cube/Caption, it's being used in PASS and PAW. I've got few ideas to propose a user interface for this so it's not a big deal.
    And lastly, this gives me an idea for the next April's fool giving weird caption to all my cubes and dimensions :-)
    Regards,


    ------------------------------
    Bob
    ------------------------------



  • 4.  RE: Cubes & Dimensions aliases

    Posted Wed June 30, 2021 12:01 PM
    Hello Bob,
    The procedure using Captions is designed for localization purposes, but the "renaming" of the Cubes, Dimensions, hierarchies, Sets would be also available using this process for the main language of your application. Here I put together steps for dimension and hierarchy TI process:
    Also, note that in your rules you can't use captions thought the alias attributes are fine. The other control objects I've been referring to such as }CubeCaptions could be the artifacts created during Performance Modeler model localization as the Caption_Default values were migrated into the cubes to represent the values.You are right that there is no way to change those caption values on the fly, this is just the way to set them up with relative flexibility.

    BTW - your April is going to be a blast no doubts.
    Best Regards,

    ------------------------------
    Svetlana Pestsova
    ------------------------------