cancel
Showing results for 
Search instead for 
Did you mean: 

Concatenating dimensions in OLAP universe

Former Member
0 Kudos

Hi,

I need to concatenate two objects in my OLAP universe based on a BEx query and wondering how to?

I tried using the "+" and it didnt work out. I couldnt find any functions too.

Please help.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You can-not concat two dimensions in the OLAP universe.

Currently it is only possible to create variables that returns Numeric values at the universe level.

Regards,

Rohit

Former Member
0 Kudos

Hi,

That's true: this is a major SAP BW limitation.

Only numeric values are allowed as result of a calculated expression.

By the way, MSAS supports such calculations.

Regards

Didier

Former Member
0 Kudos

Do we still have this limitation even after applying of SP3 ?

I want to do "Current Calendar Month - (Minus) 12 Months". As it will generate a dateformat ; Is it not possible in OLAP Universe built on SAP BW BEx Query?

Your help is highly appreciated.

-Thanks,

DEEPU.

Edited by: deep reddy on Jul 30, 2010 5:49 PM