on 12-20-2011 7:35 AM
Hi Gurus
I am using webi 3.1 and using Infocube universe
My problem is when i select calendar date i am able to display time stamp along with date in query prompt (12/02/2011 12:00:00)(MM/dd/yyyy hh:mm;ss)
i dont want to show the time stamp in query prompt as my users dislike to see that timestamp .
I thought In universe we can do it . But i searched the forums related to this but did not found .please help in this . i would appreciate ur efforts
Thanks & regards
Sunil
hey
sunil kumar!!!!
Did you solve this problem? I be suffering from the same problem. T.T
If you've ever solved, please tell me how to remove Time stamp.!!!!!!!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi sahill khurana
I am using webi 4.0
My problem is when i select calendar date(input Controls) i am able to display time stamp along with date in input Controls(MM/dd/yyyy 12:00:00 AM)
i want to see (MM/dd/yyyy) (not (MM/dd/yyyy 12:00:00 AM) )), when i select calendar date(input Controls)
where is the calendar date(input Controls)' format setting??
i dont want to show the time stamp in calendar date(input Controls) as my users dislike to see that timestamp .
Thanks & regards
hey sahil khurana
I create a variable say InputDate with below formula:
(=FormatDate([date_object];"MM/dd/yyyy") )
And use that variable(InputDate) for Input Control, then you will not see any timestamp in input control.
but InputDate's input control is not Calendar because FormatDate()'s output is string type
so I tryed variable say InputDate with below formula:
Todate(FormatDate([date_object];"yyyy-MM-dd"); "yyyy-MM-dd")
I want to use calendar Input controls..
if i select date in inpu controls(calendar),...
The results are now out of the picture below.
However, when the date was selected, I want the results below.
i know that the 12:00:00 AM is default values, so ..when I select a date, I do not want to show 12:00:00AM.
Hi park
Which data base you are using , this formatting depends on DB , suppose we take Sybase db , we can use the dataformat function in the data object to get the desired output, i suggest you to search the function for date format corresponding to your db and apply the same in universe level
and also try this
At Universe level goto business layer , double click on date object and goto to advanced properties and lower left side select the format you wud like to view , some times it might work ..that too depends on db
Hope this helps u
Sunil
Hi Sunil,
I tried your below mentioned comments...
"Which data base you are using , this formatting depends on DB , suppose we take Sybase db , we can use the dataformat function in the data object to get the desired output, i suggest you to search the function for date format corresponding to your db and apply the same in universe level
and also try this
At Universe level goto business layer , double click on date object and goto to advanced properties and lower left side select the format you wud like to view , some times it might work ..that too depends on db "
I am using Universe 3.1 and it is connect to the "DATA MART" I tried this option on the Object advanced Properties but it is not changing. I am still getting the Time Stamp in the Prompt Query.
I can able to change the format in the report level, but I am unable to changes in the Prompt Query Filter...!!
Please help..!!
Hi,
Please refer to KBA:
https://service.sap.com/sap/support/notes/1939449
I hpe this will help.
Kind regards,
Rabeb
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunil,
Time stamp in query prompt in BO 3.1 and BO 4.0 is by default.
For that you have to install BO 4.1. In BO 4.1 now time stamp is not there only date is there.
Regards,
Malay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunil ,
This is the parameter to set at the BO Server.You may need to change the Date/Time preferences in BO server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Aren't you getting any calendar interface to select the date ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
First of all thanks for u r quick reply.
yeah i am getting calendar interface
when i select calendar date from interface in interactive mode i am able to display like this
calendar date :12/02/2011 12:00:00AM how can i remove this time stamp .
i am using infocube universe . how to achieve this ?
User | Count |
---|---|
75 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.