Attribute Member aggregation in YTD view — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Attribute Member aggregation in YTD view

Summary:

Hi all,

We're looking to Set up Attribute dimension members in our Account dimension to support reporting on exception / non-exception items.

I.e. Create a P&L with accounts in the rows and then a split in the columns on exception / non-exception. Accounts will be tagged either as exception or non-exceptional.

This is working well in testing, but the balances only aggregate when the view is periodic, rather than YTD. I.e. We can only get our PBT on an exceptional / non-exceptional basis in periodic view and not YTD (using the members in the database).

My understanding is that attribute members don't aggregate into stored members, but would for a dynamically calculated one - which YTD is.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!