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.
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.
The @Time (7) worked perfectly for what I needed. Thank you so much