Is your prompt in the query itself or is it in a dashboard prompt? Let's assume a dashboard prompt. Choose "Variable Prompt": Name your variable, user input and data type. (also add a default value, if you want: Generally, Presentation Variables are referenced like this: @{varSupplier}{'default value'}, or…

Use the prompt to initialize a presentation variable, say, varSupplier. They can enter a value in upper or lower case. In your query, use a filter like this: UPPER('@{varSupplier}{xxx}')=UPPER("Bidder"."Supplier Name") This way, their prompt entry and the filtered column are both tested in upper case. I've used this many…

If you insert a page break between prompts 2 and 3, The first two prompts are submitted when "Next" is selected to go to Prompts 3 and 4.

You may have several issues here. One is that you are using both the CAST and TO_CHAR functions for the same purpose. Pick one. You also may not have access to the EVALUATE function, depending on your system, but there is no detail in those error messages, so I don't know about that. I would start by creating a column that…

You can only concatenate text fields. If CAST( XXXX TO DATE) doesn't do it, you can use EVALUATE with the TO_CHAR function to get your specific format.

Try adding a "By" clause to your calculation:

Try checking off the "Treat as Attribute" box in the "Edit Formula" window.

If your prompt populates a presentation variable, say "varAcct", you can filter your query on "tablename"."Account Number" =LEFT('@{varAcct}',14) But, this solution doesn't address all the other potential typos that may occur when users are typing in a 14 digit number.

The people in question need to be identified in the data itself. That way, the "Deliver Relevant Rows" option can be selected.

Another option is to create two separate queries for the specific graphs. Use a dashboard prompt that sets a presentation variable for say, "varGraph", with two radio buttons, "Price" and "Balance". In the query filter for Price, include the filter: 'Price'='@{varGraph}{Price}' (if Price is your default) In the Balance…

That's exactly how the function works. If you had 10 records that were each $1000, which ones would be the top 5? You can add "By" clauses to the function, if there is some other attribute you want to qualify with.

I'm not aware of any out-of-the-box way to do that on bar charts.

Your screengrab shows the column style properties. Is "All values" a prompt total, a calculated item, or a Group? Each of those has its own format settings. Did you set a conditional format? If you haven't set any of those to a large blue font, then it's a mystery to me.

I'm glad you found something that works, but you should really be working with your data base folks to model a correct time dimension, as Gianni recommended. Then, the analysis you're doing would be a simple exercise . Otherwise, it's an inefficient use of your time, and leaves a maintenance mystery for anyone that has to…

I use prompts on union queries all the time, so I'm not clear why you can't. If the Fiscal Year Prompt sets a variable "varFY", every leg of the union should contain a filter for: case when MONTH("Filters"."Business Date")<5 THEN YEAR("Filters"."Business Date")-1 ELSE YEAR("Filters"."Business Date") END IN…

If you put the formula into a column prompt, it will work, but your user will be selecting a fiscal year. Use the edit window on the column prompt: Then you can enter the formula, label it Fiscal Year. In your query, set the filter on that column to "Is Prompted".

No, you wouldn't change the column formula. You'd change the filter to include whichever Fiscal Years you want. Use it as you would any existing-in-the-data model field. If you filter on case when MONTH("Table"."Date")<5 THEN YEAR("Table"."Date")-1 ELSE YEAR("Table"."Date") END IN (2020, 2021) you could then compare Fiscal…

I used the Month and Year functions to create the Fiscal Year column. You can then filter on FY to retrieve the dates you want. Filtering on Fiscal Year=2020 will return May 2020 to April 2021. You don't have to display fiscal year, just filter on it. Of course, the best way would be a logical time dimension in your data…

I don't know how it works on this new site, which I have found to be very frustrating. I think you just marked your own answer as correct, though.

Create a Fiscal Year column using a case statement around your date field, say "Table"."Date". case when MONTH("Table"."Date")<5 THEN YEAR("Table"."Date")-1 ELSE YEAR("Table"."Date") END This places January-April of 2020 into FY 2019. Jan-April of 2021 will be in FY 2020.