I do this type of union quite often, unless I'm not clear on the OP's requirements. The first query brings in Project #, Order #, Order Value. Then add null columns of the data types matching Business Unit and Region, such as "cast(null as char)". The second query brings in Project #, two null columns matching data types…

If the objective here is to open specific sections based on the rowcount in the dummy query, then I have done something similar. My dummy query was a single column date query (Advertise Actual, below) with a filter like this: You'll have to add clauses to the filter as new options are added to the prompt.

That's '<a href=@{biServer.variables.variablename}>weblink</a>' without the red squiggles. I'm in 11.1.1.9.5.

Joel Acha's solution works for me using this syntax: Results look like this: It takes me to the correct website.

You can use a column prompt to set a presentation variable here: Then reference the presentation variable in the other subject area-filters of the union.

You can create a new column or revise the column in question using various string functions. 

The pivot charts are usually my first option, because I've found them to be more flexible and adaptable. In the position selector you can choose "chart only" to hide the actual pivot table.

I believe the issue is that the result of the MOD statement is not an integer, even though displayed as one. So when you cast to an integer, it is applied to 6.77..., not 6 in your first example. So, that "Months" statement has to be nested in a TRUNC function (bolded below). This statement: EVALUATE('TO_CHAR(%1,%2)' as…

The simplest way that I know of is to use a a pivot chart, which gives you the option: "Display as Running Sum".

Thanks. Just edited my answer.

I have pasted an answer from the Stack-Overflow website by Alex Poole - (see bottom for proper credit). I've adapted it to OBIEE front-end. Replace my "Project Schedule Milestones"."CON Complete Actual" with your hire_date. Months Diff: EVALUATE('MONTHS_BETWEEN(%1,%2)' as double,CURRENT_DATE,"Project Schedule…

Hi Adam, I have tried what you suggested, and been unable to reproduce the error. So far, it's only occurred (or been discovered) in this migrated query. My main concern is about the hundreds of migrated queries. The discrepancy was pretty obvious in the example I cited, but may be lurking elsewhere. Another quirk I've…

Glad I could help. Just an FYI: I encountered the problem while using 11.1.1.9.5. 

I have run into a similar, if not identical issue: My problem was caused by a date format that Excel didn't recognize: [FMT:DateShort] . When I changed the date format, it downloaded without problems.

I've had a lot of problems with master-detail linking across separate reports. I have had success using an action link in the base report that navigates to the same dashboard page. A hidden prompt (in dashboard properties) populates a presentation variable that filters the second report. The presentation variable has a…

Hi Sudipta, I'm no guru, and I'm working in 11G, but one method I've used is to place a hidden prompt on the target dashboard page. This is done in the Dashboard Edit/Dashboard Properties screen: I use an action link in the originating report that "Navigates to BI Content" (your target page). In your case, clicking on the…

Thanks, Christian. We'll be upgrading to .9 soon, and hopefully that will change this situation.

It seems like a space issue for wherever these charts are rendered. It also stopped rendering when I added another column to the "Points" drop area.

I just discovered the limit I'm bumping into, and a solution for this particular instance. I went back to trying a combined column and adding one condition at a time. With 10 possible combinations, it rendered up to six. This worked: But when I added a seventh, or tried to add 1B to Condition 5, it stopped rendering the…

Sorry! This was a misstatement: "It will render with a single condition, but not with a calculated combination of the two columns." (Too many trials and failures back when I had access to both 11G and 12C.) Now that I'm back into it, it won't render with any conditional formatting on any column.