cancel
Showing results for 
Search instead for 
Did you mean: 

Time Dimension rollup to yearly total issue

0 Kudos

Hi All,

I am creating a input schedule which will have monthly value constant for all the months. When i put total in IP it aggregate all the values.

My requirment is to have Month1   value in total - not aggregated value. Values are for stat account and i can set any Account type to accomplish this .

for instance

Month 1           Month 2       Month 3   ------  >>>>>> Month 12          Year Total 


2                       2                   2                                2                       24----- I need 2 in Year total

Should i consider to write local member formula to accomplish this. We are on BPC 10 Netweaver

Thank you

Neil 

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Hi Neil,

You can use AST or LEQ ACCTYPE for periodic cube for this stat account.

B.R. Vadim

0 Kudos

Hi vadim,

I have tried AST account type . It still aggregate the yearly value. I have used the account type AST and Rate type AVG and also tried rate type END as well. No luck

Please advise

Neil

former_member186338
Active Contributor
0 Kudos

Hi neil,

This is not possible. The accounts of type AST (assets) are YTD independent of cube type (Periodic or YTD). And YTD means that for YEAR.TOTAL you have the value equal to YEAR.12 (or YEAR.DEC).

Please check, may be you have some formula in the TOTAL column?

B.R. Vadim

P.S. Please provide the screenshots of report and dimension members setup.

Answers (0)