Skip to Content
author's profile photo Former Member
Former Member

Formula Variable - No applicable data found - SAP BW 7.3

Hi,

I have a formula variable based on customer exit for Last Refresh Date. The Bex is based on Multiprovider.

In the layout I have Last Refresh Date, Other keyfigures hidden and No characteristic.

The same bex works fine in BW 7.01 but in BW 7.3 it shows 'No applicable data found'

If I unhide the keyfigures then I get data for that variable but my requirement is to have Last Refresh Date, Other keyfigures hidden and No characteristic

Please provide your inputs.

Regards,

Sneha

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 27, 2013 at 03:11 PM

    HI,

    Are you sure the data is available at your Infoprovider level for the same date?

    Generate your report once from RSRT.

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 27, 2013 at 05:15 PM

    Yes, This is strange issue I also faced in 7.3. In my case Formula based on Hidden Kefigures is not showing the values but when I unhide the Keyfigure then I can see the value in formula column. So I just include *1 in Formula and problem was resolved.

    Thanks & Regards,

    Sushant

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sushant,

      In my case the formula variable is based only on Customer Exit.

      The issue is that the other figurers (which the formula variable is not dependent on) if made unhidden then the values are populated in the formula variable, else if only the formula variable is displayed then 'No applicable data found'

      Regards,

      Sneha

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.