In a BI report I created, I have a prompt screen where among other things, a user can select a year. The BI report retrieves data for that year from TM1 along with data for the next year using the NextMember function. All the dollars in every column is displaying correctly in the report but I haven't been able to display in a column heading the value of the next year. The functions available when creating the report expression don't help me. I tried creating a new data item that determined what the year's next member was but I haven't worked that into the heading yet. Any suggestions?
Click on the icon that looks like a lock. This will unlock the objects and then you can put either a layout calculation or query calculation in the header.
What do you get if you use a lead() function instead of NextMember() ? I haven't tried this but it might be worth a go...
MF.