Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Work out quarter value from debtor report Expand / Collapse
Author
Message
Posted Wednesday, June 4, 2008 12:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 12:38 AM
Points: 5, Visits: 84
Hi

I am fairly new to Analysis services and MDX

I have a question regarding how to work out the quarterly values on a debtor report.
There is a extensive time dimesion on the cube.

The problem is the quarterly values should not be the aggregate of the previoues 3 months values.

Because it is a debtor report it should only be the last month in the quarters value.

For instance - if its the first quarter then the quarter value is only equel to March,
If March is zero then the February value should be used, etc.

I saw there is a QTD, and MTD functions and tried using those without any success

Could you please point me in the correct direction as to where I should start.

Thanks
Drickus
(Dev evironment - SQL 2008 Feb CTP, VS 2008, SSRS 2008)
Post #511147
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse