Hello
i have a KF in which i am storing the difference between the creation date of a record and the system date. This is in overwrite mode in the DSO. now when i am passing these values to the cube i am tranfering them to a char as well. So the char will store the value of this everyday.so for eg if the record is open for 4 days the char will store it as 4 records.
Now my ques is
I need to use this char in reporting to create restricted kf with it. So if i want to report on number of records which were open 0-4 days. will this char work if i restrict it like this
KF
Total Number of records
char
0-4days.
Will this restricted kf give me the number of records which were open 0-4 days.