on 10-18-2005 10:23 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
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
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
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.