Skip to Content
0

lumira date selection to get YTM, opening balance, actual month...

Sep 27, 2017 at 01:55 AM

101

avatar image
Former Member

Hi expert,

I use SAP lumira to access Hana calculation view. .I would like to see many Charts for différent time period : YTM , actual month, Opening balance to actual month...

Solution 1

My accounting period have a tag (open/closed), so i can determine last closed month period in HANA. So I created calculated attribute in my calculation view : is YTM, is actual, is PreviousMonth. Then I use this filter option, chart by chart, to see what i want.

> But my customer want to be able to see March report (with actual month = March) and next to open the February report... In that case, Lumira refresh data, so last month stay at March, in February report (cause lat month depend from data in table, not from a Lumira selection).

Solution 2

I tried to use control option to select my month. But it's not OK because I cannot use this filter for the whole Lumira Story : for some chart, i need to choose January / February/ March (to get YTM) but for other chart, i need to choose only March (to get actual month). So I would need to filter chart by chart. As there are a lot of chart, my customer do not want to change date filter for each chart; each month.

And by this way, I cannot manage Opening Balance.

May be there is a way to select January / February/ March (to get YTM) for the whole story, and get something like "Last month ?"

* If user select (January / February/ March) > Lumira could also display March

* If user select (January / February/ ) > Lumira could also display February (last month)

Solution 3

I tried by prompt variable in opening doc. user prompt February > calculation view calculate my attribute (YTM, actual month...) with February.

But when I got many dataset, prompt are not merged, so I had to ipunt Feburary 4 time if I got 4 dataset... may be there is a way to merge prompt from diffence dataset..

I cannot find any fluent solution where i can let the user filtering date

* for many data set in 1 input

* for many period view, about 1 month (YTM, actual month, Opening balance...)

* to easy change last analysed month

May be someone could help me ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers