Create a dimension in olap universe

[Former Member]

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

[amitrathi239]

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