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

MDX query to calculate closedledgerbalance against time Expand / Collapse
Author
Message
Posted Friday, October 8, 2010 4:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 2, 2010 1:31 AM
Points: 24, Visits: 54
Hi ,

WE are facing problem to write MDX query that calculate close_ledger_balance against time dimension at day level:

as avg(descendants([time].currentmember.children , [day]),[measure].[closeledger])

but some how it's not giving correct value.

Can any one please guide us .

Thanks ,
Alok

Post #1001146
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse