CUME IN OBIEE 12c

User_15J6I

Hello:

  While migrating our Brio report to OBI. There is CUME function within Brio that is not available in OBIEE, how can I use CUME in OBIEE?

I need to sum values until I find a breakcol,

Thanks

Gianni Ceresa

Can you define exactly what "CUME" is supposed to do?

Or the full need you have which was covered by "CUME" ?

[Deleted User]

3744064 wrote:I need to sum values until I find a breakcol,

Can you make an example please? How does CUME work?

User_15J6I

The Cume function returns a cumulative running total for each value in a column of numbers.

Cume (numbers, break_col)

where:

numbers references the column that contains the numbers on which the cume is calculated.

break_col is a parameter that references a break column.

Example:

CUME (Amount, State)

The results are shown in the Computed column

STATE  CITY      AMOUNT COMPUTED

AZ	Tucson	112	112
CA	Burbank	240	240
CA	Glendale	97	337
FL	Palmetto	70	70
MD	Laurel	97	97
MI	Detroit	208	208
MN	Eagan	159	159
NY	New York	490	490
NY	Rochester	180	670

https://docs.oracle.com/cd/E57185_01/HIRUG/ch12s06s09.html

Robert Angel

In OBIEE you can use sum by in the formula; -

sum(yourFact.YourMeasure by State)

https://stackoverflow.com/questions/27066406/summing-by-column

Robert Angel

Better reference; -

https://gerardnico.com/dat/obiee/obis/logical_sql/group_by

User_15J6I

Thanks but OBIEE 12c doesn´t aloud that sintaxys:

nQSError:27002 Cerca de <by>: error de sintaxis nQSError:26012

and that´s my problem..

Robert Angel

Okay, see my other responses on your other thread, again in the rpd duplicating your existing sum measure and pinning it to state would be a good alternative.

#Mayur

Hi,

Please refer the following thread,

cumulative sum

Use the following function like,

RSUM(Measure BY DIm.Col)

eg.

RSUM(Amount BY STATE)

Regards,

Mayur

User_15J6I

That syntax is not allowed in obiee 12c, you can´t use by

Gianni Ceresa

As this thread is just like the other one about ColMax the same reply apply:

The "by" syntax is perfectly valid and supported in OBIEE 12c.

So give more info on what's your current situation and I'm sure the community will manage to give you some good hints on how to get over this point.