Basically reading the error You should verify that the source column definition in your Closure Table has: - Not Nullable columns where you're trying to push a null - Numbers defined as NUMBER(2) where the query is trying to push a number greater than 99. Compare the datatype with the result of the SQL generated by OBIEE…

Hi @950406 Could you check if when appearing the problem are the roles are correctly mapped in the profile? Are you using the weblogic or and external LDAP? Are you also sure no maintenance mode is enabled on weekly basis?

Hi @2896666 As for every major upgrade there is no guarantee that will work. Oracle's suggestion is always to reapply the same custom changes to a style shipped with 11.1.1.9.0

Once you understood selection steps you'll be able to do what you're asking for. If you find the answers helpful please mark them like that so others with same problem can benefit

next thing is me billing to you. I don't have the data you have. I suggest you to check how selection step work. you can find a good doc here OBIEE in IL: OBIEE- Understanding Selection Steps logic and forcing it to be based on Measures

as written before I believe you have to add the "add"/"remove" logic by clicking on a "then, New step"

why do you have 3 of REPORT_LINE_DESCRPTION I would expect to have only 1? Then all I see is a "start with", I believe you have to add the logic by clicking on a "then, New step" If you find the answers helpful please mark them like that so others with same problem can benefit

I meant the following list, can you take a screenshot of the completed list?

can you paste an image of the list of all your selection steps?

you should be able also to add...

filter by code column can be found in the prompt options

have you checked if "Filtered by code" is checked? If so can you try uncheck? what is the behaviour?

In Selection Steps you should have the option to "Keep" or "Remove" particular Values from your list and also conditionally show some of them. Adding several Selection Steps should provide what you're looking for.

So now the topic suddenly changed from "Not Working in IE11" to "Not Working with double columns"? Are you filtering two columns coming from the same dimension (e.g. Region and City) or from two different dimension (e.g. City and Product)? If the latter, are you sure that in your Fact table there is no row matching the…

If you found the tips useful, please mark them like that and close the thread. This will help others with the same problem

Can you paste the image of: - your criteria tab - your chart definition - The interaction properties of your measure

the Actions available in charts are the ones defined in columns that are NOT in the excluded sections. If you exclude the column from a sections then all actions defined with it will not be shown!

Is your closure table populated?

Hi, no, your should be able to use the default one.

can you copy and paste here the screenshot of the action definition? Btw if you find replies helpful you can mark them like that. This will help also others with your problem.