Substr in OLAP Universes

[Former Member]

Hi,

I have a OLAP universe, one of the class, example vend_compc, which is compounded with company code and vendor nbr. In the universe design, can i create an object which will hold only the vendor nbr. Similar to using substr function in oracle.

Thanks in advance.

Santosh

[Former Member · Accepted solution]

Hi,

It is definitely possible to use string fiunctions in MDX.

But you have to pay attention that within SAP the result of an MDX expression must be numeric whereas with Microsoft the result can be either string, date or numeric.

In the current verison of OLAP universes, you can only create calculated measures but you can write any MDX expression.

Here is an MSAS sample:

<EXPRESSION>mid([Product].[Product Categories].currentmember.name,4,8)</EXPRESSION>

Regards

Didier

[Former Member · Accepted solution]

Thanks for the reply.

To summarize, the current version of OLAP universes, we cannot use any type of functions returning other than numeric. All the functions available when we create a new object are applicable only for values returning numeric.

Any idea, when this would be resolved.

Thanks,

Santosh

[Former Member · Accepted solution]

Hi,

If you are using MSAS there is no restriction;

Yoy are right for SAP you can only return numeric values.

This is an SAP engine limitation. Currently to do this with BEx you need to create an SAP Exit.

I didn't have any date for the future roadmap concerning those limitations.

Regards,

Didier

[Former Member · Accepted solution]

Thanks a lot for the clear explanation.