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.

Hi, This question come back every 3 days and the answer is always the same .... Before to "improve performance" you must understand (bad) performance of your current report. What happen when you open it, where time is spent etc. Look at the first reply to this thread from @rmoff : How to improve the performance of…

Have a look at this (same as your case but with different names ...) : Column B (your "Col2") is the hardcoded value, I used 'table 1' and 'table 2' but you can use 0 and 1 as numbers. Column A is your "Col1", each logical table source point to its own column. For each logical table source you set a rule for "Fragmentation…

Well, Essbase store data as ... in a cube You can't really try to find same things as tables, views (which actually doesn't story any data) etc. A cube is built using dimensions, each dimension has one or many levels (you can also refer to them as generations: level 0 is the leaf, generation 1 is the root of the dimension…

For your logical table you add 2 logical table source, one for each of the physical table. In the column definition you hardcode the value of the 2nd column for both the LTS (so you have your source) and then you define a fragmentation rule in your 2 LTS based on the value of the hardcoded column.

Well, I understand (and agree in part) with your Essbase developers about entering values. But that's why you have calculation scripts (if BSO, if yours is ASO it's supposed to be dynamic, but I guess yours is BSO) to aggregate and propagate data to the upper levels and so you can get data with some high levels filters and…

Do you always need to set all the filters? Don't you maybe just need to set some high level one and then having the column in the analysis is enough to explore your data? Other option is to look on the cube side if it can't be designed a bit better for analytical needs.

Hi, CASE WHEN .... THEN .... WHEN .... THEN .... WHEN .... THEN .... ELSE .... END

Do you have the permissions to use Publisher? Because there is still a link there in the homepage. Plan B: go in the "New" menu and you find all the Publisher objects.