Skip to Content
0

SAP BW4/HANA BEX ERROR while restricting on a formula variable processed by replacement path

Sep 28, 2017 at 12:58 PM

80

avatar image
Former Member

Hi everyone,

Working on BW4/HANA.

We got an error when we tried to execute the following scenario :

Scenrario:

-We created a calculated Key Figure [ZNBR_JOUR] under a composite provider

- we created a formula variable [ZNBJN] under the 0CALDAY info-object processed by Replacement Path , which is replaced with a characteristic reference

- [ZNBR_JOUR] returns the variable [ZNBJN]

-we added the calculated key figure [ZNBR_JOUR] to a BEX query

- When trying to run the BEX QUERY , this error showed up :

"the variable [ZNBJN] isn't allowed in a calculated ratio"



Any solutions please

Regards,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Loed Despuig Sep 30, 2017 at 04:08 AM
0

Hi,

I think you still need to choose DATE type in this setting.

So what you are trying to achieve is to convert your 0CALDAY values to keyfigures? Am I correct?

Regards,

Loed


delete.jpg (42.3 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Loed,

Thank you for you response,

Our purpose is not to convert 0CALDAY to keyfigures , but to have a variable that counts the number of occurences of a specified 0CALDAY date .

Regards ,

0

Hi,

You may refer in my blog.

https://blogs.sap.com/?p=357718

You may also use the EXCEPTION AGGREGATION with COUNT and choose the CALDAY as your reference characteristic.

Regards,

Loed

0