You could use write back functionality to put it in a table. Or if table / database is out of the question then just create three prompts on a dashboard with freetext input, each of which populate a presentation variable. Your answers report then references them in a formula as @{C}{1} x WhateverYourMeasureIsHere etc...…

Maybe, but in OBIEE there is a 'no aggregation' option which I have had clients request as an alternative measure (sic) when they genuinely want to see full detail level, typically from drilldown to detail functionality, I have also resorted to this on occasion to get around weird measure aggregation problems usually when…

Hi, Can you try filtering your result set down, such that you only get values where ... cast (your value as int) is equal to is in 1,2,3 - where 1,2,3 are values that definitely yield a good result when you put the value explicitly rather than via the measure If this does not return the error then your problem is down to…

Your mother never tell you to show respect to the elderly?! Seriously, after more extensive searching I bow to your superior memory, I think my memory was of another BI system that shall remain nameless, or possibly Apex. I have only repeatedly found the hack, suggestions to do it with multiple reports etc, no way to snake…

Hi Gianni, I was certain I had used 'snaking' functionality with out of the box OBIEE previously on a project, without resorting to custom 'hacks' (java / css) By snaking I mean a control that let you specify wrap of sections, such that wrap horizontally after 1 report would be the magic bullet. Am I completely wrong in…

Hi, my mistake - the control I had been thinking of is in pivot tables not in table. +1 to Martin!

Don't have access to OBIEE as out of office currently, but is there not a horizontal / vertical alignment control in your sections?

Click on the XYZ control (from memory) there is a setting there that lets you 'snake' if this is what you are looking for...

Isn't that effectively what I just said? "have you also checked that your column will always have values of the range and type that the function can handle for that parameter"

Hi, I think what they are suggesting is; - 1. In Business Model layer duplicate your existing measure and give the duplicate an appropriate name 2. Edit the formula on the new measure, applying the filter as shown in the first post, after all it can be based on physical measure and you can reference other measures, or use…

So does my view selector suggestion work for you? And did you try @ArijitC suggestion re: disable_cache_hit which may solve your underlying issue?

"if I use a column instead of a static number" - presuming that all other things are equal then have you also checked that your column will always have values of the range and type that the function can handle for that parameter? Is your value a double where the function needs real integers? i.e. could the column contain…

Could you operate a workaround using the view selector functionality in answers, or are the two reports from disparate data sets? Alternatively you could put action links and have two versions of the same page, with the links navigating you from page to page, except for the report you want to display conditionally.

Can you post the exact error that manifests when you feed in your table based values? The more information you give the doctor the more likely you will get an accurate diagnosis....

To me it sounds like you are over engineering your solution. I would try and keep your user experience clean and simple.

Its okay, I hung up my ego long ago and take all humour in good humour. It was the placement in the order that made you think it was referring to my conversation with Martin.

Mocked by Picard - ouch! Ironic when he was the one who coined the phrase "Make it so"...

Does this actually cause you any problem if you use it as the basis of a filter, I am sure I have seen year variable with a decimal place previously in OBIEE, but when I actually used it against the tables it did NOT cause an issue, and if you display it you can format it obviously.

You could; create a view on the table(s) in the underlying DB - assuming it is Oracle. create a trigger to handle inserts on the view, making the trigger take the data and insert it into both tables. (Or whatever more complex logic you desire, as complex as you like!) I have done this previously to get around the…

You could resort to using the physical SQL as the basis to create the basis of an opaque view in the physical layer, this obviously takes more modelling in the rpd and is not as performant, but it will get you an answer. It might also be possible to model it in the Business Model layer using fragmentation content,…