Essbase

Get Involved. Join the Conversation.

Topic

    JackM
    Matching Level zero accounts with attribute tags in...Answered
    Topic posted September 26, 2019 by JackMRed Ribbon: 250+ Points, tagged Essbase 
    16 Views, 1 Comment
    Title:
    Matching Level zero accounts with attribute tags in Replicated partition
    Summary:
    Matching Level zero accounts with attribute tags in Replicated partition
    Content:

    Can you match level zero accounts with a specified attribute tag in a replicated partition from source to target? What would be the syntax?

    Version:
    11.1.2.4

    Best Comment

    Anviksha Shukla

    You cannot use attribute members to define a replicated partition. For example, associated with the Market dimension, the Market Type attribute dimension members are Urban, Suburban, and Rural. You cannot define a partition on Urban, Suburban, or Rural, because a replicated partition contains dynamic data, not stored data. Therefore, an attempt to map attributes in replicated partitions results in an error message. However, you can use the WITHATTR command to replicate attribute data. Also, attribute dimensions can be used but in transparent partitioning only.

    Syntax would be : @ATTRIBUTE(Caffeinated_True)

    https://docs.oracle.com/cd/E57185_01/ESBTR/attribute.html

     

     

     

     

     

    Comment

     

    • Anviksha Shukla

      You cannot use attribute members to define a replicated partition. For example, associated with the Market dimension, the Market Type attribute dimension members are Urban, Suburban, and Rural. You cannot define a partition on Urban, Suburban, or Rural, because a replicated partition contains dynamic data, not stored data. Therefore, an attempt to map attributes in replicated partitions results in an error message. However, you can use the WITHATTR command to replicate attribute data. Also, attribute dimensions can be used but in transparent partitioning only.

      Syntax would be : @ATTRIBUTE(Caffeinated_True)

      https://docs.oracle.com/cd/E57185_01/ESBTR/attribute.html