Hello

Basic structure question...

Have an account-dimension in a finance cube.

The account has an accounttype:

From a dimension table containing all acounts and the corresponding
accounttype i make and accounttype physical dimension in as. Or i make a
member
property on the account dimension and from this member property I make a
virtual accounttype dimension ?

What is the best approach and why ? (performance, simplicity, etc..)

\Michael Vardinghus

It's not a big issue either way, since this is a dimension that will only
have several members. What do you intend to do with it?

public @ the domain below
www.tomchester.net

"Michael Vardinghus" <mivar (AT) wmdata (DOT) dk> wrote

It will typically be used as a page field - we have all acounts in the
cube - the result accounts and the
status accounts - typically the result value will be chosen so only these
accounts are presented - but
sometimes the status account value will be chosen.

\Michael V.

Tom Chester <publicNOSPAM (AT) tomchester (DOT) net> wrote

I suppose I'd probably make it a physical dimension, no strong opinion
though.

Is it really needed though? What are the types? Could they be members of
Account dim?

public @ the domain below
www.tomchester.net

"Michael Vardinghus" <mivar (AT) wmdata (DOT) dk> wrote

No it I don't see how they can be members of the account dimension - an
account can be referred to only one
account type.

Found some better english terms:

AccountOperations, AccountStatus

When looking at AccountOperations i see the net result for the company -
when looking at accountstatus i see
the assets and liabilities - when looking at both i see the total picture.

We also have a separate dimension with the total sum account structure with
3 levels.

\Michael V.


Tom Chester <publicNOSPAM (AT) tomchester (DOT) net> wrote

If I understand correctly it is typical for these to be part of the Account
dim -- the accounts rollup to these members. Such as...

Balance Sheet
Assets
aaaaa
bbbbb
Liabilities
ccccc
ddddd
Income
etc.

public @ the domain below
www.tomchester.net

"Michael Vardinghus" <mivar (AT) wmdata (DOT) dk> wrote

Preciously !!!!


Tom Chester <publicNOSPAM (AT) tomchester (DOT) net> wrote