Increment numbers in a row

[lebronjames]

Hi everyone,
I have a D-List with a field called Pay Period #. When I put this list as part of a cube, I want it to display an incremental series of numbers for every column

1  2   3   4   5   6   7......

How would I put this into an item? Is there some kind of calculation or BIF that I could use?

Thanks in advance.

[mrobby]

There are ways to do this but it depends on how you want to manipulate the data.

If your DList IID's are sequential then the @Time BIF with function 7 will return the IIDs of the timescale

You could use two extra items in your DList and in one set the calc to =1 and in the other use the @Cumul BIF to cumulate the item you just created.

Use an assumption cube to feed the period number to the item you want through a Dlink if this suits you for contributor


Just have to get creative and youll find all kinds of ways to solve problems.

[lebronjames]

The @Time (7) worked perfectly for what I needed. Thank you so much