I’m working on a report in Desktop Intelligence 12 and I need help.
I’ve found the function Previous(), but actually I need the opposite: Next. Is there such a function?
The reason I need this is the following:
In a crosstab, I’ve got columns with the most recent dates (irregular frequency), made with a ranking. For each date, there are amouts underneath it per vertical dimension. I’m not interested in the actual amounts, but in the increase on the previous amount. So my measure should be: Difference=-
The thing is that Previous amount=Previous() refers to the wrong direction.
It might be WebI only and it might be my imagination but I’m sure there is something like this now. It may be an optional argument to Previous or it maybe a differently named function (I don’t think it was next). Have a look in the category of functions to which Previous belongs to see if there is anything with an appropriate description…and check out the full syntax for Previous, in case there is an optional argument.
I can’t find anything about an optional argument not in the hint while entering the function, nor in the help. I tried entering a , and a value after the >. This resulted in an error: too many parameters.
In the help, I can not find a category where Previous belongs to, other than “Functions”. So I can’t search anywhere but in the entire list and there I’ve tried every naming I could think of.
Oh, in WebI the functions are listed alphabetically but also categorised - I think Previous may belong to a Miscellaneous category…its either the painful process of working through each one or hopefully someone will shout up with the answer.
Hi,
How about RelativeValue function in Webi (XI 3.1) which Returns previous or subsequent values of an expression calculated using a set of dimensions.
SYNTX:=RelativeValue(expr;slicing_dimensions;offset)
Eg:RelativeValue([Revenue];([Year]);1) returns the next value.
Curses. If you have access to the universe, you may be able to leverage database functions to do this. The example I always give is Oracle’s lead and lag functions.
Or, if you alter the order the reports, doesn’t your need for ‘Next’ suddenly become a need for Previous…I guess that just isn’t a goer?
I read this yesterday and knew there was some way to do this, althoug was not sure, with regards to Deski.
Its always a problem when you are switching versions, tools, you forget what can do what… .
That’s not really a big deal: I don’t care too much about the order, but I don’t think that’s possible with the way I created my list of 8 most recent dates: it’s a top 8 ranking, which is automaticly displayed as most recent left and older right. Applying a sort removes this ranking.
I’ve managed to just create a new variable with Previous() to move te dates along with the data. The real data are still in the table, but I hid them bij making them white.
(BOB member since 2002-08-15)
(BOB member since 2002-08-15)
.
