Formula variable not working.

[Former Member]

Hi BI/BEX experts,

I am creating an aging report in AP using 2 formula variables. One fomula variable is giving the right value that is on key date but the other formula variable which is on 0BLINE_DATE is not getting replaced. It is givinf X in color red. Thus calculation for number of days is coming as X in red.

We are using 0BLINE_DATE as a free characteristics. If we use in row, it is working correctly. But we cannot use it in a row as users want a consolidated report on profit center.

We are sing SAP BW 701, Level 008 SAPKW70108.

Any help is appreciated.

Thanks.

Sheo

[Former Member]

Hi,

Try NODIM function in formula.

Regards,

Anand Mehrotra.

[Former Member]

Thanks Suhas.

But even though, the date is not displayed, it is displaying the extra lines related to the profit center. Is there a way to get rid of extra lines and just display the consolidated figures on one line?

Thanks.

Sheo

[Former Member]

I am having the same issue as Sheo.

I have Clearing Date (CLEAR_DATE) as a characteristic.

1. I have Clearing Date (CLEAR_DATE) in the Rows section
2. Created a formula variable based on CLEAR_DATE
3. Created a calculated key figure using the formula variable from Step 1
4. Put CKF from Step 2 into Columns section
5. Run report and everything works fine
6. Remove Clearing Date from Rows and the CKF turns into red X

Also, just like Sheo, if I just change the Clearing Date in the rows to "No Display", there are still extra lines because the Clearing Date is still there, but not displayed.

Question: Is there a way to have a date (which a characteristic) used in formulas/CKF without it being in the Rows section of Analyzer. Thanks!

[Former Member]

Hi,

Try to change the supress the rows and columns with Zero.

Thanks

Ganesh Reddy.

[former_member185132]

Hi Sheo,

This is normal behaviour. If you want to fill a formula variable using a characteristic, that characteristic should be there in the rows. Now as your requirement is to not show the characteristic, you can add 0BLINE_DATE in the rows, and set it to "No Display". To do this, In BEx, add 0BLINE_DATE in the rows, select the characteristic, go to Display tab and set the "Display as" dropdown to "No Display".

This will allow your formula variable to pick up the value of 0BLINE_DATE and will also hide the field from your users.

Regards,

Suhas

[former_member199691]

Try using exception aggregation, it might work.

else you will have to caculate no of days in cube itself.

Regards,

Gaurav