nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE Concat issue

Pahadia

Hi,

I am trying to get 2018 Q2 from this expression

CONCAT(CAST(YEAR(CURRENT_DATE) as CHAR),' Q',CAST(QUARTER_OF_YEAR(CURRENT_DATE) AS CHAR))

However I am getting "Formula syntax is invalid." error

If I use first two or last 2 of the concat string it works but all three together not working.

Any thoughts whats wrong here.

Find more posts tagged with

Accepted answers

All comments

Sherry George

Look at the syntax for OBIEE CONCAT function.

CONCAT(CONCAT(CAST(YEAR(CURRENT_DATE) as CHAR),' Q'),CAST(QUARTER_OF_YEAR(CURRENT_DATE) AS CHAR))

Gianni Ceresa

What Sherry George said.

You can't "invent" the number of parameters of a function yourself: CONCAT requires 2, exactly 2 parameters. You try to use 3, can't work, so embed and extra CONCAT to first concatenate 2 pieces and then concatenate again 2 pieces and done.

PS: OBIEE isn't Excel accepting as many parameters you want

[Deleted User]

Gianni Ceresa wrote:You can't "invent" the number of parameters of a function yourself...OBIEE isn't Excel accepting as many parameters you want

Amen and halleluja

Chris Arnold

Have you tried just using the pipes to concat? Something like this:

CAST(YEAR(CURRENT_DATE) as CHAR)||' Q'||CAST(QUARTER_OF_YEAR(CURRENT_DATE) AS CHAR)

Adam Wickes

Is it a regular occurrence for people to receive their answer and then take off like they were never here. A simple thank you wouldn't go astray surely?

[Deleted User]

Say "thanks"?! Are you mental?

Pahadia

Thanks a lot for solution. It perfectly worked.

Pahadia

My apologies all. I could not get chance earlier to come on board & say "Thanks you"

This board has been so helpful & you guys are very generous with your time & efforts to reply & provide guidance.

Thanks a million again !!!!