cancel
Showing results for 
Search instead for 
Did you mean: 

Typical report and it's data model!

Former Member
0 Kudos

Hi,

i have a data source which has only three fields, namely user name, date, availability of the user ( it is character string of length 1 just displays A if he is availbale and displays N if he is not availbale on a given date).

now when i want to create cube , it should have at least one key figure, where as in my case no key figures are present in the available three info objects.

is der any chance for me to design this ?

Many thanks in advance.

Thanks,

Ravi

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ravi,

enhance your communication structure with an additional infoobject, a key figure that acts as a counter (or you can do it into your cube, if you prefer)...then you can fill it in transfer rules (or update rules) with a constant "1"...

Now you will be able to do your report and to show a counter that allows to analyze how many people is available or not too...

Hope it helps!

Bye,

Roberto

Former Member
0 Kudos

Hi Roberto,

Thank you very much for the reply!

But i do not know the term you used "counter" for key figure. can you elaborate more on that key figure! i had serached in rsd1 for info objects but could not find any kf that is relevant!

Thanks,

Ravi

Former Member
0 Kudos

Hi Ravi,

I was referring to a custom KF that you can define as an integer (with one digit) and that you can feed (with summation as aggregation mode) with "1" for each record related to a single person...

Let me know if you need more help!

Bye,

Roberto

Former Member
0 Kudos

Hi Roberto,

Thanks again for ur answer! Now i understand what u mean !

but how the logic of appending the key figure will be included in the model?shall i need to write a routine for that?if yes, how the logic would be?

Thanks,

Ravi

Former Member
0 Kudos

Ravi,

are you talking about KF append into a cube?

If you want to add a KF into an already existing (and filled) infocube, you need clearly to know which is the filling logic (maybe you have something available from datasource or you need to put your own logic).

Anyway, you will need to reload your cube in order to fill all the hystorical data already contained in the provider...

Bye,

Roberto

Former Member
0 Kudos

Roberto,

Thanks again!

yes,i was talking about that KF only.we have data source (made by FM and ES) which is perfectly working for the three fields which all are characteristics as i told u before!

But since we cannot make any infocube with out KF , i wish to have KF for only making cube!since u suggested to go for any counter which would be acted as appending records for each user in the result set!

now if i want to load this field in the data source, i need to change the logic of FM, which i am not so comfortable and quite lengthy too.

My question to u is whether i can go ahead by simply creating KF and in Transfer rules or update rules include a simple logic of giving numbers for each record rather than changing the code in FM in R/3 ( which i feel is more complex )?

Thanks,

Ravi

Answers (0)