Hi together,
we have the following requirement: Develop a mobile report with one startpage and three dashboards (finance, sales, stock/inventory)... The datamodell is DMR.
My goal is to have only one report and only one page. Using decks, datadecks and buttonbars.Ther is an "overall"-deck for every page/card(startpage, finance, sales, stock)
So, I started with the finance dashboard. Therefore I built 2 versions
There should be 2 dropdowns (one for filtering month (36month) and one for filtering organization type(14 orgatypes)). In the report page, there has to be a
- crosstab showing 8 accounts in rows and in the columns actual month, PY, plan, delta plan, actual YTD, PY YTD, plan YTD, delta plan YTD and a last cloumn which shows the development of the accounts over last 12 months in a bar chart (using a microchart and a master-detail-relationship to the corresponding account; total 8microcharts in the crosstab - one for every account)
- chart showing 2 accounts and the development of the last 12 months.
How I built version 1:
Created a datadeck (with month and orga in the deckelements) and in the datadeck there is the crosstab. Now, i "told" the month and orga dropdown to select the corresponding deckelements in the datadeck. Additionally, I needed to filter the crosstab on orga to get it working... In this version everything works fine (controls, dimensional functions etc.), but there is a massive performance issue. I tried to save the report on the server over night...started at 8 p.m., next day at 6 a.m. report was still running. After "pre-filtering" on only 2 months and three orgatypes the report took about 5 minutes. By the way the mht-files is about 5mb)
Because of this performnce issue I had to reconsider the development of this dashboard. So, I found 2 useful tips: 1. try not to use nested datadecks and 2. try to segment list/crosstabs...
So I built version 2 trying to apply those tips:
Using one datadeck to select month and inserting in the dataeck a deck with 14 cards - one for every orgatype. That means, in this version I have 14 crosstabs (and added the corresponding orgatype to the columnheader of each crosstab and still the microcharts in it) and 14charts. In this version the orga-dropdown is no datadropdown, it's a "normal" dropdown where I had to put in every single orgatype. Here, everything works fine, as well. And here we go: the same report runs in about 1hour with no "pre-filtering" on month or orgatype. BUT the mht-file is about 15mb and there should be two more dashboards added in this report....
So, summarizing:
Version 1: - runs to slow, but the mht-file size is ok
Version 2: - runtime is ok, but the mht-file is way to big
So, please any ideas suggested to get the runtime and the mht-file size "ok"? ;D
If more detailed information is needed, please, let me know!
thx
McSaesh
Hi guys,
let me kindly ask again:
Does anyone have an idea?
greetings
McSaesh