very urgent

[anilkumar]

hi guys

advance thanks

i am using cubes as  datasource

i need columns like this

A)  actual ytd(pre year)   B)     actual ytd(pre year)      C)actual ytd(curr year)    D) A-C
      (2008/apr)                       (2008/mar)                     (2009/apr)


Thanks and regards
anil kumar

[david.stachon]

Open Report Studio, and the package that points to your cube

choose a list or cross-tab

drag what you need from the left hand pane onto the report.

...then use the calculate button to do your A-C.

[anilkumar]

Hi david

i need queries yaar.

regards
anil

[david.stachon]

...sorry Anil, I don't know what you mean by "i need queries yaar".

[anilkumar]

hi david

iam developing one report  using cubes as a datasource.

please go through attachemnt.
i need urgently.

regards
anil kumar

[david.stachon]

so what have you tried doing? ...and what are you having difficulty with?

[vinay17in]

There are several analytical function you can use to get the data for previous year same month and previous year

parallelPeriod
lag
lastPeriod
closingPeriod

[anilkumar]

Hi Vinay

if i  get pevious year actual data  is  enough.
can u send query for  previous year ytd .
previous member i used but it is not working with the actual ytd.



regards
anil kumar