SQL Logic to add Account

[Former Member]

Hi Expert

please suggest SQL Logic to Add this same account for different time period for same Year

CATEGORY RPTCURRENCY YEAR ACCOUNTFBENTITYCOSTCENTER FBTIME SIGNEDDATA

MAYF GBP 2010 ACCPYCALC CEGB11SED20950 2010.APR 150

MAYF GBP 2010 ACCPYCALC CEGB11SED20950 2010.MAY 250

MAYF GBP 2010 ACCPYCALC CEGB11SED20950 2010.FEB -500

Regards

Gayu

[Former Member · Accepted solution]

Hi,

If you want all the time periods, it will be anyways aggregated in the parent member of the time dimension. For ex, 2010.TOTAL will have the sum of all the months. But for this the hierarchy should be maintained. If you are using the standard time dimension, then you need not worry about it.

Hope this helps.

[Former Member · Accepted solution]

Hi Nilanjan

My requirement is a to write the total value to a FILE. When Category is MAYF then required to ADD

ACCPYCALC accounts for period Jan,FEB,MARCH,APR can we do this with YTD if so how please.

MAYF GBP 2010 ACCPYCALC GB11SED20950 2010.APR 150

MAYF GBP 2010 ACCPYCALC GB11SED20950 2010.MAY 250

MAYF GBP 2010 ACCPYCALC GB11SED20950 2010.FEB -500

Reageds

Gayu