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

Calculated Keyfigures in Queries

Hi Experts ,

I got new requirement ....

I have one basic Keyfigure Constrained forecast (Fc)

for period X

and I have one Field "Equal Numbers"

If(FCx1=FCx2=FCx+3;u201DYu201D;u201DNu201D)

I have to compare the 3 respective period sles.....

the Equal number should be populated according to the above logic ....

"Equal Numbers" = 'Y' or 'N'

Fiscal year/period X (single,Mandatory) = 001.2007

X+1 = 002.2007

X+2 = 003.2007

X+3= 004.2007

How could I do this at Query level ?

and Pelase let me know if there is any alternative solution...for this.....

and one more thing ...

I have one more field "Minimum Sales per a month" in the selection criteria ... Which was not there in the Cube level... and the value for this is 1Metrci Tonn to infinite....

and also the field "Average coming 3 free periods "

I have whih should be restricted as below...

Average(FCx1;FCx2;FCx+3)u201D

Filter on >Minimum sales a month

How could I do the above those two at the Query level.....

In cube level I have only one basic KF Constrained forecast (Fc).....

and please let me know if we can do at the cube

level...

is there any possiblity of Virtual Char/ KF .......

Could any body help me reg this...

Thanks in Advance ....

Regards,

Nagamani Bollineni

Edited by: nagamani bollineni on Jun 17, 2008 7:50 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 06:56 AM

    hi,

    U can create three new selections with ur key fig FC and restrict them with fiscal period and put offset of1,2 and 3

    Then create a new formula where u compare this 3 anddisplay "y" or "N"

    To find avg u can create one more formula on the three

    Add a comment
    10|10000 characters needed characters exceeded

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.