Question:
Hi,
i have a special request for the BEx-reporting:
the bw-cube consist a year-to-date key-figure; the BEx-report should consist a monthlz-based variable (from-to); the result should by
month month+1 ...
KF ytd(month) ytd (month+1)
minus ytd (month-1) minus ytd (month)
So, the results should be calculated dynamically in every cell.
Is there some experience (may be with visual basic or is there a solution with web-reporting ?)
Answer:
Just a question, maybe a dummy one ?
Why did you put this strange key figure instead of monthly one ?
I don't know how to solve your problem directly in query. Of course, with VB it could be done, but I can't give you a generic code to do that. If needed, I can send some code I developed, but you'll have to adapt. Better for you to register a macro and then adapt the code.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
unfortunally, it's not a dummy question; the cube consists only the year-to-date key-figure, it's a external data-source, loaded by flat file, and they deliver (however it's ridigolous) only the ytd-values.
can you send me your coding please to dieterhild@web.de, many thanks in advance
Answer:
I suggest you to change your cube, and to adapt the update rules in order to calculate the monthly figures at loading, instead of trying to solve the problem with querying.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.