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

Virtual Keyfigure giving error while Query execution

Hello Guys,

Reporting Requirement here is to

Display a ROLLING Key figure which is a sum of Previous Four weeks.

So if we are in Jan st week, the key figure should be the sum of last 4 weeks (which effectively is December month).

In Jan 2nd week, the Key figure should be the sum of last 4 weeks (which is 3 weeks for December and 1 Week for January)

So if I run the report today (2nd week of October), I should get individual columns for last 36 months with this calculation applied to for each column.

We tried to create a Cell Editor and put in a Virtual Key figure there to populate the data. The Virtual Key figure works fine/ok in Development environment. The moment we transport the code to Quality and the huge data comes in..the Query starts failing. Tried to debug it as well using RSRT, but it does not even come to the Code and gives an error message.

Did anybody faced something like this ever before?

Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 10, 2008 at 04:53 PM

    Hi Rohit,

    I think you are trying to fill some internal tables in the code which could be failing because of limitations.

    You can verify it in the test system by giving small selections and see if it issue with the huge amount of data only.

    Virtual key figures have a limitation of performance and is not recommended if dealing with huge amount of data as it will very slow and may lead to faillure as well.

    Thanks

    Ajeet

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 10, 2008 at 06:43 PM

    Hi Rohit..

    We had similar problems and went on to discover that there is a 2Gig limit on internal tables... Please check the amount of data you are evaluating and limit that if possible..

    Ashish..

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Guys for your replies.

      Seems the issue was with the way the Code was implemented.

      We are now able to run the code. Still need to check it for Quality/Production data if it works for a huge dataset.

      Regards

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.