Retail Predictive Application Server (MOSC)

MOSC Banner

transfer slice of today mnth_str_clss to mnth_str

edited Mar 15, 2020 6:03AM in Retail Predictive Application Server (MOSC) 3 commentsAnswered ✓

Hi experts,

My RPAS version 13.2.2.37

I would like to create two measures:

meas_1 -- baseint: mnth_str_clss, type: real, -db: yes

meas_2 -- baseint: str_clss, type: real, -db: display-only

When a workbook is built, I want the meas_1 slice of today is assigned to meas_2.

I tried three methods.

Method 1:

meas_2 = if(current == today, meas_1, 0)

It doesn't work, meas_2 gets unexpected values.

Method 2:

meas_2 = tssum(meas_1, today, today)

It doesn't work.

Method 3:

A middle measure is needed.

mid_meas -- baseint: mnth_str_clss, type: real, -db: display-only

mid_meas = if(current ==  today, meas_1, 0)

meas_2 = mid_meas.level([clnd].top)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center