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

How can I auto-increment a member name in a flat dimension?

Summary: In a hierarchy dimension, I can auto-increment a member name by using the PreviousSibling methods in the Calculate and Store expression on the name property. However, the *Sibling methods seem to have no meaning in a flat dimension.

What am I trying to do? (I'm glad you asked) I have a flat list that I would like to allow users to add to via interactive request. However, the list is sequential and each new member should equal the previous member's name +1.

Why am I not using a sequence property? (I'm glad you asked) A sequence property will not work for the following reasons…

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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