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