Hi,
I have a AS 2005 SP2 cube with an Account dimension for financial statements.
I need to use the ByAccount AggregateFunction property setting to ensure that both the Balance Sheet and Profit and Loss statements calculate correctly, however for reasons unknown i cannot get the correct calculations to display.
If i set the AggregationFunction property of my measure to SUM, the numbers add corrctly accross all dimensions, including time (Not wanted for Balance Sheet numbers). If i set the AggregateFunction of my measure to LastNonEmpty, the numbers add correctly accross all dimensions EXCEPT time (great for Balance Sheet accounts but not for rofit and Loss).
I've deployed my project and processed all my dimensions, however when using the ByAccount, my balance sheet numbers are still aggregated over time!
I've rechecked the Account Intelligence settings and cannot seem to find where the problem is.
Can anyone suggest a solution?
TIA.
Cheers,
Leigh
"If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem
I have a AS 2005 SP2 cube with an Account dimension for financial statements.
I need to use the ByAccount AggregateFunction property setting to ensure that both the Balance Sheet and Profit and Loss statements calculate correctly, however for reasons unknown i cannot get the correct calculations to display.
If i set the AggregationFunction property of my measure to SUM, the numbers add corrctly accross all dimensions, including time (Not wanted for Balance Sheet numbers). If i set the AggregateFunction of my measure to LastNonEmpty, the numbers add correctly accross all dimensions EXCEPT time (great for Balance Sheet accounts but not for rofit and Loss).
I've deployed my project and processed all my dimensions, however when using the ByAccount, my balance sheet numbers are still aggregated over time!
I've rechecked the Account Intelligence settings and cannot seem to find where the problem is.
Can anyone suggest a solution?
TIA.
Cheers,
Leigh
"If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem