Skip to Content

CALDAY and CALMONTH as date field

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 04 at 11:08 AM

    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

    Add comment
    10|10000 characters needed characters exceeded