cancel
Showing results for 
Search instead for 
Did you mean: 

KF default types

Former Member
0 Kudos

I have a KF that I am calculating while loading the data ie in the update rules.

but in some cases the business wants this to be blank when a particular IO in the source is initial.

For this how should my KF be defined. I have defined it as integer. but in the update routine even when I say RESULT = ' '. , I see the value update as 0. Cant an integer be left blank. Theres no problem with the code.

Help needed !!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

If a record is created in the cube, all the KF values in it are 0 even if not explicitly populated. Blanks appear in reports corresponding to selections for which there are no records in the infoprovider. So if you want blank to show in the report for this particular KF, you can make it a separate selection (for eg, use a separate value of version) which you don't create for the cases when you want to see blank.

Former Member
0 Kudos

this KF is not in the cube . Instead its an attribute of a characteristic Infoobject. I am looking at the master data of that infoobject.

does whatever you mentioned above stands true for my case too?

Former Member
0 Kudos

hi,

try loading this master data through ods,hope that will make the entries as blank.

I am not sure, you can try passing the result value as INITIAL if no value in the IO .

Ramesh

Former Member
0 Kudos

it is already coming through an ODS.

just to be sure that my code is correct, I am posting my code(actually picked up from SDN) here

Is there no other way that can be used to get the KF as initial in cases where the condition is satisfied ?

Former Member
0 Kudos

Hi,

Yes it will be true. In any record you create, a KF will automatically be 0 if you don't populate the value explicitly. But if it is masterdata, I am not sure if you can show a blank in the report.

Former Member
0 Kudos

Same stands true for Master Data as well.

a key figure can never be blank be it in the cube or the master data.

I created a characteristic IO of type CHAR and then you can do your calculations in teh reports by using a replacment path exit.

Answers (0)