Home > Business Objects > @prompt Syntax In Business Objects Universe

@prompt Syntax In Business Objects Universe


Be optional! It's similar to another solution posted earlier in the comments. When you create a condition on the query panel, one of the operands should allow you to configure a prompt. You can ignore the parsing error and save the prompt as it is, export your universe, and test it to see if it works. http://alltechgossip.com/business-objects/business-objects-4-0-error-inf.html

You may find that even if you put in a prompt definition which does not parse- it still works in WebI Back to top BO_LoaderForum MemberJoined: 11 Apr 2008Posts: 5 Posted: The value free does the former, and the value constrained requires the LOV selection. I scanned the responses to see if my question was already asked. I can test in 3.0, but I haven't installed 3.1 anywhere yet.

@prompt Syntax In Business Objects Universe

Prerequisites: Language dimension Created. Comment by BOSleuth December 10th, 2009 at 1:25 pm I have XIR2 SP4 and I am obviously doing something very wrong here because I cannot get these prompts to work for My observation on what you have posted is that it works perfectly if the user only uses text tokens that get translated to date values. Its a very long approach, but it work.

  • Comment by Dave Rathbun February 19th, 2009 at 10:35 am The ability to order prompts never existed in Deski.
  • Condition (Pre-Defined filter) in BO Universe designer Overview: It is a best practice to create pre-defined filters (known as conditions) to help end business users to define the required filte...
  • Derived table: you can use this function in your derived table query. [Click here for more information about how to use prompt with derived tables] Tips and Tricks: You
  • Things I really REALLY wish prompts could do… Set a default with a variable.
  • Is there any settings to enable this option or how else can I insert query prompt in DeskI report.
  • But let's investigate and explain a bit further than that, shall we?
  • Thanks in advance.

Based on my previous comments I've made, lets say the user does'nt want to see the word "yesterday" or "today" in the report header. Some components may not be visible. Call them "Begin Date Display" and "End Date Display" Create a new variable for report header section. Any value entered for that parameter is treated as data, and no formulas or calculations will be calculated.

case @prompt('Enter the ending month number (1 - 12):' ,'A',{'Last Month','1′,'2′,'3′,'4′,'5′,'6′,'7′,'8′,'9′,'10′,'11′,'12′},Mono,constrained,Not_Persistent,{'Last Month'}) when ‘Last Month' then To_Number(To_Char(add_months(sysdate,-1),'MM')) else To_Number(@prompt('Enter the ending month number (1 - 12):' ,'A',{'Last Month','1′,'2′,'3′,'4′,'5′,'6′,'7′,'8′,'9′,'10′,'11′,'12′},Mono,constrained,Not_Persistent,{'Last Month'})) end Comment A reader with extremely good attention to detail will notice that the syntax I posted above does not match what was shown in the user manual. Comment by Zaif December 7th, 2010 at 9:09 pm Hi Dave, So can we manage to get the desired results using “magic date” and your some creative logic, If yes then You really have only a few options.

Comment by Nix January 8th, 2009 at 6:20 pm What about the 8th parameter User:n that determines the sort order when the prompts are displayed ? XHTML: You can use these tags:

Confirm submission by clicking only the marked checkbox: ** Please remember Julian on November 16, 2011 at 6:06 am said: Hi Dado, as far as I can tell dynamic dates of any kind are not supported for default values. Thanks.Rohini 1578Views Categories: Analytics Tags: none (add) universeContent tagged with universe, unv0023Content tagged with unv0023 This content has been marked as final.

Extended Prompt Syntax Business Objects

Our business users would like to see the list ordered and first select from a range and drill down. The user field is for controlling the position of prompt, but in 3.0 you can do this via the query properties- unfortunately it works only for report level prompts and not @prompt Syntax In Business Objects Universe thanks in advance. How To Create Optional Prompt In Universe they are right but to a certain extent.

It took lots of time for BO to come up with the feature while cognos was using it from a long time. weblink Can anyone please help me in this regard.   Regards, Sahil 0 0 04/20/14--22:39: SAP Business objects Error: UNV0023 Contact us about this article Hi   While creating a @prompt in M Comment by Bill July 24th, 2009 at 1:27 pm Hi, I am looking for a way to make the parameter optional ie. This help will be deeply appreciated.

Many of the "extended" parameters for prompts that Web Intelligence will create are not fully supported within the Designer application. Here's a hint: don't make a prompt constrained without providing a valid list of values source. Try this, its for Oracle though, but I'm sure you SQL nuts will get the idea: Create a derived table. navigate here In the universe condtion you may put your prompt as sequence 2.

Comment by Dave Rathbun December 13th, 2009 at 9:08 am Hi, thanks for your comment. Then, make the two filters (Date Picker + Date X Filter) part of an "OR" statement. I am sure this can be modified to have the Default as DATE, of course, depending on the syntax differing upon the selected Database.

Could you please explain these with example??

Comment by James November 5th, 2008 at 12:28 pm Hi Dave, I heard from a person that is close to BO that 3.0 (or 3.1) supports "today" or "now" (or something It's a good idea to let the user know what's going on and to provide some clue as to how the prompt will operate. Regards, Shiva Comment by Dave Rathbun August 26th, 2009 at 8:55 pm Hi, Shiva, as I mentioned in the post I will use that as a topic for a later blog The administrator should grant this permission to this user.

If your prompt will return multi value use IN operation instead of equal (=) Note that not all users having permission to view list of values while they trying to run The database user names and passwords are not the same as the BOBJ ones. In order to get the object to parse I had to follow the exact syntax shown in the function help in Designer rather than what is in the documentation. his comment is here Welcome, and thanks for your question.

Example # 1 (simple prompt): We need to create a new condition that will prompt user to enter a valid date to display data related to this date in our report. Instead, I would create a predefined condition in my universe that prompts the user by asking, "Do you want US or All Other?" If the user answered US, then only US Using Index Aware Objects With Prompts Recall that index awareness is designed to create more efficient SQL. Dave I did not find a better explanation anywhere else on the web.

A prompt can be created on a report or in the universe. Comment by Mark Penner January 8th, 2009 at 11:48 am Hey Jon, I am getting the same error and have not found anyway to correct it. The problem is that in this case the space becomes e default value but I need a mandatory prompt without any default value, with User paremeter specified. For example, @Select(Batch Type\Batch Type Code) = @Prompt('Batch Type','a','Batch Type\Batch Type Code',mono,constrained,Persistent,{},User:1,Optional) and it is working WebI.

I am on XI 3.1 Comment by Suganya May 23rd, 2012 at 7:42 am Hi Dave, Could you also explain how to work on ‘query prompts' in DeskI. Saleem on April 14, 2013 at 6:31 am said: Hi, This is the code for a Derived table i created in BO Universe. BO Universe Parameters Overview: This is a step by step tutorial and user guide on how to configure your universe parameters. I have to schedule a report to run on every monday.

i have given this parameter as 8th parameter but am getting parsing error as ‘Error parsing default values parameter(7th parameter)' can any one help me on this? So anything like sysdate or getdate() or CurrentDate() is going to fail. If it works, you can consider leaving the code in place even if it doesn't parse. This particular universe is on the data in MySQL database.

There is still no way to enforce that the second selection matches the first because the prompts are independent. The short answer to the question, unfortunately, is no. Add details to seperate date class. Stack Overflow I received errror : Error parsing default values parameter (7th parameter) … I have universe built on SAP BW 7.1, we're on Business Objects 3.1.

Comment by Dave Rathbun October 14th, 2008 at 9:26 pm Hi, Irishorizon, welcome to my blog and thanks for your comment. I have heard of some tool called BobJ. Error parsing default values … CRM does give you error messages every now and then. I am currently more acquainted with Infoview and I was wondering if I should invest time in trying to study better reporting tools than this.