How to reduce the Loading time in Access Point dashboard?

[lawrance]

Hi,

Please tell me how to reduce the below Loading time in QMC

(2017-01-13 15:56:07) Information: Loading. LoadTime=00:00:01.0140260

(2017-01-13 15:56:09) Information: Loading. LoadTime=00:00:03.0420780

(2017-01-13 15:56:13) Information: Loading. LoadTime=00:00:07.0981820

(2017-01-13 15:56:21) Information: Loading. LoadTime=00:00:15.2103900

(2017-01-13 15:56:37) Information: Loading. LoadTime=00:00:31.4348060

(2017-01-13 15:57:09) Information: Loading. LoadTime=00:01:03.8836380

(2017-01-13 15:58:10) Information: Loading. LoadTime=00:02:04.7251980

(2017-01-13 15:59:11) Information: Loading. LoadTime=00:03:05.5667580

(2017-01-13 16:00:12) Information: Loading. LoadTime=00:04:06.4083180

(2017-01-13 16:01:13) Information: Loading. LoadTime=00:05:07.2498780

(2017-01-13 16:02:14) Information: Loading. LoadTime=00:06:08.0914380

(2017-01-13 16:03:15) Information: Loading. LoadTime=00:07:08.9329980

(2017-01-13 16:04:15) Information: Loading. LoadTime=00:08:09.7745580

(2017-01-13 16:05:16) Information: Loading. LoadTime=00:09:10.6161180

(2017-01-13 16:06:17) Information: Loading. LoadTime=00:10:11.4576780

Thanks,

Lawrance. a

[lawrance]

Hi Sommer,

Could you please explain how to resolve this problem, if any other solution

Thanks,

Lawrance A

[rwunderlich]

I recommend you start by taking a look at the Document log to see where is the script the time is spent.

-Rob

[lawrance]

I checked the Document Log there is no delay. Reload time takes only 5 minutes but distribution takes more time. Please find the attached screenshot for your reference.

Thanks,

Lawrance A

[Dhirendra_Kharwar__13373]

My datamodel qvf file size is 3.5 GB and my dashboard loading time is 7 minutes. please help how can I reduce the datamodel loading time.

I used the aggr() with a date range in the set expression it is required.

and also distinct count.

[marcus_sommer]

There might be no easy way ... else it could mean that a re-design of the application would be needed to develop the application in the direction of a star-scheme (only a single fact-table + n dimension-tables) and avoiding if-loop and aggr() within the UI.

- Marcus