Home > Business Objects > Business Objects Error Parsing 7th Parameter

Business Objects Error Parsing 7th Parameter

Contents

Any query in information design tool already does this as well as the preview values for the LOV object. Query fo Max FYQ = Select : max(Fiscal_Year+PCQR_Quarter) Where : Archive IS NOT NULL Then I create this @prompt(I have error when tried to parsed this prompt, which I dont understand and the case statements are defined in another table as prompts with (CASE @Prompt('1. It even mentions the primary_key attribute which was apparently present (and usable) in XI R2. Source

Quick response is appreciated. I am sure this can be modified to have the Default as DATE, of course, depending on the syntax differing upon the selected Database. Is there a way to make large LOV function this way in webi query/report? When I write {”} it still gives an error but if I put space: {‘ ‘} it passes.

@prompt Syntax In Business Objects Universe

Thanks in advance. Go to "Insert condition" and under Where of the condition we put: @Select(Date\To date)=decode(@Prompt('1-To date:','D',,mono,free),'t',trunc(sysdate),@Prompt('1-To date:','D',,mono,free)) Which means that a user can input any date he/she wishes when manually refreshing reports, Comment by AB January 11th, 2012 at 11:35 am It seems we cannot use UPPER before @prompt.Here is the code which does not work for me:: UPPER(TABLE_NAME.PRDCT_NAME) IN UPPER(@Prompt('Select Product' ,'A', You have to remember we are using Deski for our reporting as Webi is currently too limited in functionality (no grouping of variables for instance - I know you can do

  1. The funny thing was that I did not have to install anything to enable it.
  2. Do cascading prompts effectively.
  3. I can't find any clear/detailed documentation on how some stuff should work (stuff like table breaks - and alerters & sorting applied on table breaks, variable qualification functionalities - measure variable
  4. The error message will go away. @Prompt('Select a Market','A','Scan Track Market\Market Name',Multi,Constrained,persistent) Thanks Madhu Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest

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. Thank you Comment by Joyce October 23rd, 2014 at 3:18 am Hi Dave, I have been using date range prompt(sample below) in most of our universes. Best Regards, Vikram Comment by Dave Rathbun November 29th, 2008 at 12:41 pm The only way that I know of to link a universe LOV within a free hand SQL data Comment by Zaif December 11th, 2010 at 7:58 pm Hi Dave, I mean Can I Make “Today” as My Default Prompt Value?

One quick question regarding Index aware- when set on a object at a hierarchy level higher than the primary key grain, the LOV shows repeated occurance of the object value as I want the user to specify the customer number once with a prompt rather than for each query. Hopefully IDT will bring the best of "Business Views" and "Universes" together (one hopes…) Comment by praveen April 5th, 2015 at 11:59 am In prompt properties you have an option default Back to top bob2210Forum AssociateJoined: 23 Sep 2010Posts: 597 Posted: Thu Aug 16, 2012 12:22 amPost subject: Re: @Prompt error (7th variable) Remove the last comma from your below mentioned code

thanks, Srinivas Comment by Dave Rathbun August 3rd, 2009 at 8:07 am Hi, Srinivas, and thank you for your comment. You have to create some sort of work-around where a hard-coded value gets dynamically reassigned, which is the technique outlined here in this blog post. The curly braces are also used when providing a hard-coded list of values, so I guess that's not too surprising. What have two connections -- one that has a hard coded user name and password and it is used for scheduled refreshes by a super ID.

Extended Prompt Syntax Business Objects

I will do that. The report has a date prompt. @prompt Syntax In Business Objects Universe Hope that clears it up for you. How To Create Optional Prompt In Universe To reiterate something I stated earlier: These are report options only.

Typicall they should contain all the values for the parameter already built as previous post. this contact form Formatting the column produces exactly the same no matter the what date format you choose. I can test in 3.0, but I haven't installed 3.1 anywhere yet. Is there a way that the prompt or date picker can be formatted to only show the date 8/15/2014?

The numbers do not tell much, but the …… ← Previous Post Next Post → If you enjoyed this article please consider sharing it! But I previously posted a workaround. I've tried scheduling the report with these options and it runs sweeeeet. have a peek here When you create a condition on the query panel, one of the operands should allow you to configure a prompt.

First, the prompt text. If I wanted to make a hard coded list with the values "Yes" and "No" on it here is the syntax: {'Yes','No'} The values are surrounded with curly braces { } Wiki NewForum - Powered by vBulletin – January, February, March, April, May, June, July, August, September, October, November, December 1st, 2nd, 3rd, 4th, 5th, 6th, 7th, 8th, 9th, 02th, 03th ……

I tried using negative numbers and found that they came out ahead of the 0 value one from WebI but were sorted alphabetically on the text of the prompt.

If I dont't put User it works fine but I need to tell the prompt the order that I need but for fill in the User parameter I must specify a So I am trying again my luck to check from your forum if this is availe, adding a dynamic value as a default value. Julian on November 24, 2011 at 12:47 pm said: Hi Prasanthi, for me, "quick prompt" refers to the prompt that one can quickly create from WebI. A user would be "free" to enter the value if they wanted to, but it would be validated against the LOV provided in the universe.

I use the following formula to set a formula based default value for the prompt:
Year = @Prompt('Select the past year since when you wish to view the data:','N','Dates\Year',mono,constrained,persistent,{'(YEAR(CURRENT_DATE) Go to the universe(s) that are used to build a report. The first two are generally considered required while the remaining three are optional. Check This Out Default Value(s): If left blank no default value used.  If a value or values is desired then the set should be surrounded by { } characters and separated by commas (much

Unfortunately, it doesn't work. But when additonal value (Ex KPI02) is being added to the characterstic KPI identifier the webtemplate opens only in display mode. Julian on November 29, 2011 at 8:52 am said: Hi Maddz, I see that you are using the "@Variable" function and not the "@Prompt" function. You could add some SDK code as a custom prompt handler but that's beyond the scope of what I'm able to provide on my blog.

As I found out, what ever is provided inside {"} as the default value, is treated as text and placed as it is in the SQL query that gets generated. Error parsing mono/multi parameter (7th parameter). @prompt(‘Enter the … default value needs to be provided in @Prompt definition else it throws parsing error. I wonder if this is the reason our universe-level date prompts aren't working in Deski apart from the ones that return a ‘fixed' date (like current FY end) as opposed to So basically I have created an object to select the maximum/latest fiscal year & quarter and names this as Max FYQ.

Comment by Dave Rathbun June 10th, 2010 at 10:25 pm Hi, Daif, thanks for your comment. i have given this parameter as 8th parameter but am getting parsing error as ‘Error parsing default values parameter(7th parameter)’ But in BO XI r2 SP2 it is parsing fine. thanks in advance. This is present in XIr2 and can be seen when looking at the SQL for a query within WebI.

Any tips/tricks from you? I already have the basic query pulling all the info, I just don't know how to have WI break this out for me. Comment by Arun December 11th, 2009 at 10:47 pm I am using Bo Xi 3.1 SP2 FP 2.2 how to use “User:n” parameter in prompt? RathbunPowered by WordPress•Podcast Technology from podPress Skip to content Skip to menu Dave's Adventures in Business Intelligence ...you are in a twisting little maze of passages, all alike...