cancel
Showing results for 
Search instead for 
Did you mean: 

Calender month as key figure

Former Member
0 Kudos

Hi all,

I want to pick calender month from calender day and make it as an entry of data feild of ods.

For that, how can I define the info object as key figure, holding calender month.

I mean to say if it gives me a value of 11.2005 and if i give an offset in variable as 12 then it should return me 11.2004.

So how well can i get this desired output.

One more thing is, if we define an info object key figure of type date and data type DEC, how will it store this value. This is infact to know, how can i code in update routine to get month from it and store.

Regards,

Naveen.A

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

I hope, you can use 0CALMONTH Info object for your pupose.

In the upadte rule of 0CALMONTH you will use couple lines of code to take the first 6 characters from date field(either 0CALDAY of your own date field).

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Hi Anil,

I cant define it as a characteristic, as I am going to use the same data in a multicube and at that point, i will get a mis match in key feilds, which distract the purpose. So any other go?

Former Member
0 Kudos

Hi,

My understanding is :

1) you are going to use Multi provider

2) MP will be built on the First data target (the ods for which we are discussing and one more Data target

3) In second data target you already using the 0CALMONTH

4) so you do not want to use OCALMONTH in first Data target (ODS )

Am i right?

If so , Define a Z infoobject with reference of 0CALMONTH.And use it in the ODS.

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Hi,

My understanding is :

1) you are going to use Multi provider

2) MP will be built on the First data target (the ods for which we are discussing and one more Data target

3) In second data target you already using the 0CALMONTH

4) so you do not want to use OCALMONTH in first Data target (ODS )

Am i right?

If so , Define a Z infoobject with reference of 0CALMONTH.And use it in the ODS.

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Dear Anil,

You absolutely correct in the points you have mentioned about the requirement.

I have infact created another info object of type 0calmonth.

With this we can have cal month in the ODS.

But when I go for identification of char in MP, I need to set the info object's reference to its corresponding provider. Then, when I load a record to MP from the basic info providers, I will get two records, in two lines rather than in a single line, as all characteristics are not matched. In this particular case, its about 0calmonth and zcalmonth.

So the purpose wont suffice.

Hope you understand, what I am trying to explain!

I can as well go for creating an info object of type, key figure and data type character, which may return me a value 052005, lets suppose, if i give it an input of lets say 21.05.2005, but I cannot offset the month ,as I require in query.

This is my exact limitation.

If any further expalnation is required in this regard, please let me know, so that I shall coem out, with my best possible.

Please help me oiut to come out of this.

Former Member
0 Kudos

Hi,

I hope, I understood to some extent. In my scenario, I thought that the ZCalmonth ( built by the reference) will be used for restriction key figure (here you can built the offset on this object also).

That means you will take the common characterstic( common to both Data targets) to rows.

So think in this manner for your requirement. And I will try to help you in any other way also.

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Hi,

For eaxmple we have one ODS ODS1 and One info cube IC1.

And assume the objetcs in ODS are:

Customer,product,region,zcalday,KF1

And assume the objetcs in Info cube are:

Customer,product,country,0calday,KF2

So assume you have taken the fileds in to Multi provider as:

Customer,product,zcalday,0calday,KF1,kf2

In idetification you will do like this:

Customer = ODS1

= IC1

product = ODS1

= IC1

Zcalday = ODS1

0calday = IC1

And let us assume you have records in ODS1 as below:

Customer,product,region,zcalday,KF1

C1,P1,R1,1.10.2005,100 INR

C1,P2,R1,2.10.2005,200 INR

And let us assume you have records in IC1 as below:

Customer,product,country,0calday,KF2

C1,P1,CO1,10.10.2005,10 EACH

C1,P2,CO1,12.10.2005,20 EACH

So the records in MP will be

Customer,product,zcalday,0calday,KF1,kf2

C1,P1,1.10.2005, ,100 INR,

C1,P1, ,10.10.2005, ,10 EACH

C1,P2,2.10.2005, ,200 INR

C1,P2, ,12.10.2005, ,20 EACH

So that here in the reports on MP , you will not use the un common characterstics in rows(zcalday,0calday).But you will use them in restriction KF.

But you can make restriction on KF1 with only zcalday ( not with 0calday)

Similarly you can make restriction on KF2 with only 0calday ( not with Zcalday).

I hope, you will get some useful information .

With rgds,

Anil Kumar Sharma .P

Answers (0)