Skip to Content
avatar image
Former Member

Create a dimension in olap universe

Hi,

I am using OLAP universe. I have Detail Object for Account ID with the name L01 Account Key.

It has values like
LX/COA1/10000

LX/COA1/10012

LX/COA1/100015

LX/COA1/10020
LX/COA1/10025
LX/COA1/10035

I need to create a dimension in the universe by grouping the Account IDs and specify a name for each group.

That is some thing like below

If([0ACCOUNT].[LEVEL01].[[20ACCOUNT]].[Value] between 10000 and 100025 then "Account1" else
If([0ACCOUNT].[LEVEL01].[[20ACCOUNT]].[Value] between 10026 and 100050 then "Account2" end

I think I need to do the below two steps.

1. Take the number alone i.e. 10000 from LX/COA1/10000
2. Create a if statement like above. I am not sure of the syntax and how to create it in XML format.

Can anyone please guide me. Is this approach correct? This is the first time I am working on OLAP universe.

Thanks in advance


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 21, 2012 at 04:13 AM

    HI,

    Create one variable account first for to get account value.

    =substr([L01 Accoutn Key]);9;14)

    by this you will get only account number.

    Then create one condition on if else.

    =if([account] between(10000;100025)) then "Account1" elseIf([account] between(10026;100050) then "Account2" else [account]

    Thanks,

    Amit

    Add comment
    10|10000 characters needed characters exceeded