Create a new key figure with apply a specific selection

[Former Member]

Hi,

I need to create two calculated key figure within the query.

Available info object : CustName , AccessDate, BillAmt

Key Figure formula:

KF1 = Count the No of CustName where AccessDate is greater than or equal to system date

KF2 = Count the No of CustName where AccessDate is less than system date

note : system date is not available in the cube yet.

How can i create this in the Query Designer on version 7.0

Thanks

[Former Member · Accepted solution]

HI

Create TWO Caluclated key figures using the if consition(Booleman functions).

KF1 = AccessDate is greater than or equal to system date

KF2 = AccessDate is less than system date

in columns you can create the structure in the create the selection

Selection1(ZX1): take Customer number and KF1

Selection2(ZX2): take Customer number and KF2

now go to the ZX1 and ZX2 properties select the count option and set the characterstic to caluclate the count.(ex: if you want to caluclate the count on customer there you selct the count and select the customer characterstis.)

Regards,

chandra.

Edited by: chandrasekhar reddy on Sep 18, 2008 3:26 PM

[rajkumar_kandula]

Hi,

For that create another ODS with two extra KFson that Cube.

In update rules for those two KFs you can write two simple routines to acheive your required result

So that you can build your query on ur new ODS

Revert back for further queries.

Regards,

Rk