If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Perfomance and/or file-size issue with active report

Started by McSaesh, 07 Apr 2015 07:23:21 AM

Previous topic - Next topic

McSaesh

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

McSaesh

Hi guys,

let me kindly ask again:

Does anyone have an idea?

greetings

McSaesh