CALDAY and CALMONTH as date field

[former_member462823]

HI All,

I have a chart in my design studio application which shows data for all days in the month.

So the date field is DD/MM/YYYY.

User wants to see only DD/MM. Can this be done in design studio. Not sure if the CALDAY object from the BW be adjusted to show only DD/MM as it may be used in many other applications.

Thanks

[TammyPowlas]

I would add 0CALMONTH to the BEx Query and then show it in Design Studio

In Lumira Desktop (where you tagged your question) you could use the date/time hierarchy; personally I like to make these types of "transformations" on the back end of query; your application will run faster