cancel
Showing results for 
Search instead for 
Did you mean: 

Display all days of a given month

former_member713182
Participant
0 Kudos

Hi:

In Query Designer, how can I display all days of an entered month as a Characteristics? (let's say in the rows). I need to display it even of there is now data for a specific date.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Raj

Have you tried drilling across using 0CalDay?

Regards,

former_member713182
Participant
0 Kudos

Hi...

this is not useful because dates that have no data, will not be displayed.

Any other idea?

Former Member
0 Kudos

Hi Raj,

Try using offset of the entered variable then u can get the values if present or not if they are not present

Thanks

vamsi

Former Member
0 Kudos

Hi Raj

Create ZCALDAY infoobject. Maintain master data in that object such that it has dates for all days in the year. Include that in the multiprovider on which your query is designed. Now drill across using Zcalday.

Regards,

former_member713182
Participant
0 Kudos

Hi.

Do I need to map this zcalday with any fileld in the tranformation to the cube?

regards,

Former Member
0 Kudos

No, do not include ZCALDAY in your cube. It should be an independent infoobject that you will include in your multiprovider.

Regards,

Answers (0)