Month subject OBIEE sort order

Mallikarjuna Kuppauru-Oracle · Dec 17, 2023 11:02PM

As per uploaded image, you can remove the first line which is not required.

Column formula --> Remove the first line an keep remaining case statement.

"Calendar"."Month" -- remove & Validate the formula and run the report.

Regards,

Arjun

User_LL6E2 · Dec 18, 2023 1:02AM

Thanks Arjun. I must be missing something here. I think I have done as per your advice, but still get the error messages. Image attached.

Mallikarjuna Kuppauru-Oracle · Dec 18, 2023 1:14AM

Below are the changes required to fix the syntax issue -

Formula 2nd Line --> after When you have 2 double codes remove 1.

From last to 2nd line you have 2 double codes remove 1.its should be "Calendar"."Month".

Correct and validate the formula .

Regards,

Arjun

User_LL6E2 · Dec 18, 2023 1:23AM

Done, still errors. Sorry!

RajeshPolavarapu-Oracle · Dec 18, 2023 1:38AM

Your syntax looks correct in the screenshot.

Looks like there are some special characters.

You can copy the entire case statement to a notepad and then remove double quotes and re-enter them using your keyboard.

User_LL6E2 · Dec 18, 2023 1:46AM

Thanks Rajesh. Ive done that too. Ive double checked and still cant see any typos.

Attached.

Mallikarjuna Kuppauru-Oracle · Dec 18, 2023 1:47AM

'JAN' then10 --> 'JAN' then 10 ( Need space after then ) same as 'FEB' then 11

Regards,

Arjun

User_LL6E2 · Dec 18, 2023 1:50AM

Thanks Arjun. That sorted it, but now I get the attached errors after running the report?

Mallikarjuna Kuppauru-Oracle · Dec 18, 2023 1:58AM

You need to see your session log for more details. We can't resolve the issue with out seeing the session log file.

Regards,

Arjun

RajeshPolavarapu-Oracle · Dec 18, 2023 2:00AM

Did you get this error after editing the Month column ? or You saw this previously as well?

Did you get the error message instantly? or after sometime?

If it is after some delay, then please check below document for solution -

OBIEE 12c: Analysis failed after a fixed time - Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P (Doc ID 2311291.1)

MFA for Oracle Community