3025352 wrote: Here are the screenshots! I am using the CASE in a column filter Are you really using that in a filter? You know what a filter is, right? In SQL a filter is a condition supposed to be resolved into TRUE or FALSE to include or exclude results from the resultset ... So just your CASE WHEN can't be a filter !!!…

Can you try by adding "DATE" ? CASE WHEN "Agreement Sent Date"."Date" <> DATE'1969-12-12' THEN "Agreement Sent Date"."Date" END

Same issue on SampleApp 511, did you try to contact MOS for that to see if it's a known issue and if not to report it? Didn't check if the last bundlepatch they released some days ago change something ...

1969 or 12-12-1969? Because you talk about "Agreement Sent Date"."Date" is 1969 but then check only for the 12.12.1969 (so you are missing the other 364 days of 1969 ....). Second thing: why CAST(null as timestamp) ? Null is just null, so simply return NULL directly and don't lose time trying to cast something that can't…

Thanks Christian Shubham, Just to be clear: you want to have a variable list of values in the prompt based on the role or it's only the default selected value that must change but the list of values is always the same? (it changed between your first post and the last one ...)

And you can also open a ticket with Oracle for that so maybe you will have access (as tester) to an earlier patch before to be publicly available in a BP.

Hi Ali, The official tutorial cover the basic basic things, but the tool is quite big and is extremely powerful in generating queries, so you will never have a tutorial covering all the topics. I would say that for all these things you better start following the main blogs about OBIEE and ideally attend events with a BI…

Well, the error is different at least, already a good step All your rows have a value for Candidate UDF Value 01 ? All the values are a valid date ? Don't you have Nulls values there somewhere ? If one is NULL you must manage it.

Sorry but if you posted that your date is in the format "yyyy-mm-dd" why are you trying to use a "mm/dd/yyyy" format? Cesar did 2 examples, one as the format of date you posted (yyyy-mm-dd) and it works fine. So what does your date really look like? Maybe double check that part as you aren't really sure (I don't think you…

It depends on the format of your date but try with TO_DATETIME('your value', 'the date format')

So you want a DISTINCT C1, C2 ? Because I don't really see what you try to have with a GROUP BY but no aggregation ...

I saw another post where @Christian Berg was saying there is actually an issue with that session variable in 12c. Let's see if he can post something more here ...

You are the one having the model in front of you, so double check all the joins etc. Mainly if you changed the model from an existing one with a different format you maybe forgot to add / delete / edit few things.

CASE WHEN your condition on UDF Value 06 THEN your value UDF Value 04 WHEN your condition on UDF Value 02 THEN CASE WHEN your is null condition on UDF Value 01 THEN UDF Value 04 ELSE your calculation on UDF Value 01 END .... Do you actually have OBIEE in front of you? If you edit the formula of a column and look at the…

It doesn't contains 2 THEN in one condition ! It contains a IF ... ELSE as the THEN of one condition. Just write the same if you want to keep it simple and not change anything else: WHEN .... THEN CASE WHEN .... THEN .... ELSE .... END ELSE .... You can have a CASE WHEN into another CASE WHEN (and many times)

OBIEE_Drool wrote: I am not sure if MOD function works in OBIEE 11g. Yes, MOD is an OBIEE 11g function SelectedMod‎SyntaxMOD(expr1, expr2) Whereexpr is any expression that evaluates to a numerical value. ExampleDescriptionDivides the first numerical expression by the second numerical expression and returns the remainder…

68fc5b55-3695-410a-b07d-a1ca9650c76e wrote:... include 5000 Presentation Columns ... What are all the issues I will face in future because of this. Well ... An unusable, unmantainable subject area for sure ... I would definitely challenge the requirement because it doesn't really sounds like an analytical requirement ...

9ea58984-68d0-43ac-91d2-74d13f9639c4 wrote:... the dashboard crashed ... Sorry but .... what does "dashboard crashed" means? Because it can't really crash as it isn't a process / service / program or anything that can actually crash.

In S_ACT_EMP don't you have the activity ID (the foreign key) ? Set a COUNT aggregation on it and you get your number, all the dimensions can be modeled starting from there ...

+1 for Christian, you probably can get most (all?) of your metrics by using the S_ACT_EMP as fact table and activities and employees as dimensions.