Current Position:Home > Date formats in BI Query designer

Date formats in BI Query designer

Update:11-30Source: network consolidation
Advertisement
Hi gurus
We have enhanced our cube 0sd_co3 where we have taken a number of dates such as Railway Receipt date, Actual Goods Issue date, LFdat, thses are only few examples. Now our reporting scenerio demands reporting based on thses dates as given in our time dimensions such as
YYYYMM        Qty
but not based on the date mapped in the time dimension in the cube. but based on these dates
in oracle we have the to_char function through which we change the format of date while writing sql query
so if there is any option of changing date format in query without changing the modelling
Pl suggest
Thanks
Shivani

The Best Answer

Advertisement
Hi,
You can create new characteristic of char number 6 . Include it in the data target. Populate it via a update rule ( Routine).
Use input as standard date (Railway Receipt date) and then pass the value to the new char in the required format (YYYYMM). Follow same thing for other dates also.
Let me know if you have doubt.
Regards,
Viren
  • Date formats in BI Query designer Update:11-30

    Hi gurus We have enhanced our cube 0sd_co3 where we have taken a number of dates such as Railway Receipt date, Actual Goods Issue date, LFdat, thses are only few examples. Now our reporting scenerio demands reporting based on thses dates as given in

  • Date Format changes    in   Query Designer Update:11-30

    Hi friends,           I have one  date field that is Keyfigure (not  a Time charecterstic) ...now   i want to display date in  DD- MON - YYYY format... but  up to modelling side my date format is DD.MM.YYYY.....        i dont want to change in modell

  • Date format in BI query Update:10-11

    Hi, We need to display a single date format independent of date format of SAP User settings. For ex: as below. In a current query the  date, depending on the user's configuration could appear as: dd.mm.yyyy (English format)         or        yyyy-mm-

  • Date Format in a query of (attribute Object) Update:11-30

    Hello to all experts and BW users, I have question regarding the format of a date characteristic in my query.I was wondering if it is possible to show a date field in the following substraction: 31/12/2006 in 2006. I want to change the format(dd/mm/y

  • How to convert milliseconds to date format in sql query Update:11-30

    Hi All, The following code is in java.      String yourmilliseconds = "1316673707162";** Date resultdate = new Date(Long.parseLong(yourmilliseconds)); could you plese tell me how to convert milliseconds into date format in query and comparing wi

  • How i can change date format in the query Update:11-30

    I have made a query and Document date format is DD/MM/YYYY but i want Document date Format as YYYYMMDD. Please help me out as soon as posible. Thanks is advance.Hi Harman, By default query shows same date setting what is maitianed in SU01 (user maint

  • Change date format in reporting (query) Update:11-30

    I need to change date format from dd.mm.yyyy to dd/mm/yyyy in reporting (query)Hi Suresh, Go to transaction su01d in that enter your user. Now go to defaults and change the date format. Ya but this format will be user specific, so if you want everyon

  • Keyfigure value by comparing 2 date fields, in the query designer. Update:11-30

    Hi all, Could any one please intimate, how to display the key figure result with the comparison of 2 date fields. We are having "Completed Date" say(CDATE) and "Deadline Date"(DDATE) values in the report as time characteristics, dervie

  • Date format at the query Update:11-30

    hi Can  You Please suggest how minimal we can correct this at the query output My coming output for the date field at the query is 01/28/2008 04/27/2006 06/1/2006 05/16/2006 Desired Output for the query field at the query is 1/28/2008 4/27/2006 6/1/2

  • Checking correct data format using sql query Update:11-30

    1) I got column date of joining which accepts date in below format DD-MON-YYYY DD-MON-YY MON-DD-YYYY MON-DD-YY Month DD,YYYY Question:- how do i check whether all dates in Date of joining column are in above format or not using sql query? 2) I got on