Home > Default > Heilp me in date as defalt date as prompt

Heilp me in date as defalt date as prompt

November 30Hits:0
Advertisement
Hi all,
I am working in SQL 2000  data base,
i want to create the prompt in universe as condtion...current date as defalt prompt:..
EX:- end user must not take date as manually .. it must take defalt date as sys date
Regards,
Venki

Answers

Hi Venki,
       1.      Create a Object with Current_Date() and name it as  Today.
2. Create an Object named Prompt
@prompt('Description eg Enter Date','datatype','class\Today','multi/mono','free/constrained')
3.Pull the Object in the Query panel.
Regards
Prashant
Edited by: Prashant Sathyapalan on Oct 13, 2008 1:49 PM

Read other 6 answers

Tags:

Related Articles

  • Scheduling a report with System Date as promptOctober 11

    Hi Experts, We have came across a requirement where users want to have a date prompt. While scheduling the report, by default prompt is to be populated with system date and it (prompt) should also allow us to select a different date. This report is u

  • Disable "Send Data File" promptNovember 30

    When I open the pdf created in LiveCycle Designer 7.1 and click on "Submit to Email" it prompts me for what type of email app I use. It then presents the "Send Data File" prompt. The options are "Send Data File" "Print F

  • Data Manager promptNovember 30

    BPC 7.5 NW SP11 Question: Can i have the data manager prompt give parent node selection by default instead of only base members I have product dimension with ProductLine as parent node and Product Item as base member. In one of our process we have a

  • Heilp me in date as defalt date as promptNovember 30

    Hi all, I am working in SQL 2000  data base, i want to create the prompt in universe as condtion...current date as defalt prompt:.. EX:- end user must not take date as manually .. it must take defalt date as sys date Regards, VenkiHi Venki,        1.

  • Report that uses web services as data source, prompts for database logonOctober 11

    I have a crystal report that uses web services as a data source. When I deploy the report to Infoview it prompts me for a database username and password. Since I am not using a database it should not prompt me for these. I tried various options in th

  • Parsing Failed for Date in PromptOctober 11

    Hi Folks, I am having Parsing Issue on "Key Date"  Object in Universe. See the Error and Code below for your review Error: Parse Failed: Exception: DBD, The value entered is not valid. It must adhere to one of the following formats.           YY

  • Setting a date in PromptNovember 30

    Hi all I need to set sysdate in my Date Prompt in a "DATE" Format,and I m using system.currentTime When I use system.currentTime, It is taking the CurrentTime Stamp. which is failing in fetching records. I just want exact Date in "MM/DD/YYY

  • How to acheive between and condition for dates in promptsNovember 30

    Hi all, can any one tell me how to achieve between and condtion in obiee 11g i used like this, i in the filter i put active date is between and put two presentation variables(pre_var1 and Pre_var2) and in prompts is used to one prompt active date is

  • Regarding current system date as promptNovember 30

    Hi all, I am very new to this obiee. I am trying to set the dashboard prompt value as the currnet date. But i am not able to get it. were to set to set variable and how to set it. Please any one can help me. Thanks a lot for your help Ahi, Current_da

  • Date , Year PromptNovember 30

    Team, We have 2 prompts: 1 for Date 2 Year. Basically what we need is that when a user click on any date, the year part of the Date prompt should be displayed in the YEAR prompt. So is there a way in which we can use a Presentation variable for this

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.943 s.