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...

Regards,

Nagamani Bollineni

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

10|10000 characters needed characters exceeded

Related questions

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

10|10000 characters needed characters exceeded
• Former Member

Hi Vijay,

Could you tell me How can we display the Y/N

in Query itself....

Do we need to create any Virtual Char ....

Regards,

Nagamani