|
Home > Archive > MS SQL Server OLAP > April 2005 > Calculated cells performance
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Calculated cells performance
|
|
| Michael Vardinghus 2005-04-24, 8:23 pm |
| Have a scenario where i need to make currency conversions at level 6 of a
dimension - when doing this i lookup a currency cube using a member prop on
level 1, month, and the name of the currency unit at level 6.
This is put into a calc measure and I then use calc cells to do the
conversion to a subcube at level 6, month - however performance is terrible
and I actually don't have that many records - only appr 500 thousand.
In the hierachical dimension there could be appr 20.000 members at lowest
level.
What do I need to be aware of ?
Of course there can be something wrong with the syntax in another calc
member on top of the measure that is changed by calc cells - don't have many
calc members though - only lookup currency and another one to get the right
sum's.
| |
| Chris Webb 2005-04-25, 7:23 am |
| Can you show us the MDX you're using? If you're using the LookUpCube
function, then that would be one likely cause of poor performance (although
this kind of calculation usually does perform badly) - can you use a virtual
cube instead?
Chris
"Michael Vardinghus" wrote:
> Have a scenario where i need to make currency conversions at level 6 of a
> dimension - when doing this i lookup a currency cube using a member prop on
> level 1, month, and the name of the currency unit at level 6.
>
> This is put into a calc measure and I then use calc cells to do the
> conversion to a subcube at level 6, month - however performance is terrible
> and I actually don't have that many records - only appr 500 thousand.
>
> In the hierachical dimension there could be appr 20.000 members at lowest
> level.
>
> What do I need to be aware of ?
>
> Of course there can be something wrong with the syntax in another calc
> member on top of the measure that is changed by calc cells - don't have many
> calc members though - only lookup currency and another one to get the right
> sum's.
>
>
>
|
|
|
|
|