Cal Month que

[Former Member]

Hi

I have a requiremet for the current year ,where Calmonth is in rows and Product in columns. Now I have all the 12 months in rows.

Though now the currnet month is April. Layout should be like this

Filter: cal year

Month----P1-p2---total

Jan10---1-2---3

Feb10---23----5

mar10--3-1---4

Apr10---- -

---

-

---

May10--- -

---

-

---

Dec10---- -

---

-

---

Tot-----66--12

How the months may,jun..jluy...Dec will apprear in the report.

Please advise on this..

Regards

bipower

[former_member185181]

create new selection for all 12 months and restrict it by calmonth.

[Former Member]

Hi,

Create a new selection in the rows for Calmonth. Restrict it by the variable 0CMONTH and add the offset.

[Former Member]

Hi

Above suggestion are not fullfilling my requirement. Let me give more info on this

I need to have standard structure in the rows with all 12 months(Jan...Dec) and in the filters i'll enter the desired year and it should display that years months.

Hope its clear

Please advise on this...

[srikanthbwbw]

Hi,

Create a structure in the rows. In structre create a selection on 0calmonth and restricted to 01 and also include your calyear with a variable selection. do this for all the 12 months. When you enter your year it will display all the months

Restriction

0calmonth-->001, 0calyear "Variable"

0calmonth-->002, 0calyear "variable" and so on

Thanks

Srikanth

[Former Member]

Hi

Can explain how to achieve ..when restrict teh calmonth by 001 where shuld give 0calyear variable..

Please explain the steps...

Regards

[former_member185181]

right click on rows, create new selection

now drag and drop calmonth

right click on calmonth in right pane and choose restrict.

Select single values from drop down menu

choose first month.

repeat the above steps for all 12 months

now for each selection, after restricting calmonth, drag and drop calyear.

right click->restrict

choose variable option.

select required variable and transfer to right of restrict window.

This step should be repeated for all selections.

[srikanthbwbw]

Hi,

In rows right click and create selection. Drag your 0calmonth and restrict it with ex 01. Then drag year to the same selection and restrict with 0calyear with variable

next create other selection with 0calmonth = 02, Then drag year to the same selection and restrict with 0calyear with variable

next create other selection with 0calmonth = 02, Then drag year to the same selection and restrict with 0calyear with variable

Repeat it 12 times.

Cheers

Srikanth

[Former Member]

HI

Its not working..when I restrict the calmonth to 01..it gives the error

01 is not a number with 0calmoth spaces..

While restricting calmonth..i seleted the single value and enter 01 and pressed ok

then i dropped the year and enter the variable..

Please advise on this..

Regards

[former_member185181]

for calmonth, select single values and select the month from list of values shown. Do not enter manually.

[Former Member]

Hi ananda

When i select the sigle values its shows diff values like April 2008 etc it doesnot show any values like 001 or 01..

Please advise..

[srikanthbwbw]

Yaa thats right you cannot derive only month from 0calmonth. its YYYYMM.

[srikanthbwbw]

Hi

Are you on development server or your cube is still in production?

Thanks

Srikanth

[Former Member]

HI

Thanks for the reply , in the above posts experts are asking to enter the value as 01 what that refers to...

I am working on the dev box and querying on the Masterdata object.

How to achive my task...

Please advise...

Edited by: Bi power on Apr 15, 2010 8:14 AM

[srikanthbwbw]

Hi,

Thats good. We had a same issue of deriving week from 0CALWEEK.

create a char object length 2 and include in target. When you are uploadind the data write a routine to populate month number in the character so that in report you can derive month number

thanks

srikanth

[Former Member]

Hi Srikanth

Could you please share the code with me..

Regards

bipower

[Former Member]

Hi Srikanth

Could you please share the code with me..

Regards

bipwer