#1 2019-08-27 22:01:48

Patryx
Member
Registered: 2019-03-25

Pivot mode in dynamic list -> how to refresh cube

Hi,
Is there any other way to refresh cube than Revert button in cube (pivot mode)?
I set parameters in Parameter's tab, I go to Preview, I create my cube (I set measures, columns, rows etc) - I see my data.
But I want to change some parameters values, so I go to Parameter's Tab, change parameters (for example range of dates), I go back to Preview and there is no reaction, still data from previously set parameters. Now I have to click Revert button in cube and, what's horrible and really not user-friendly, I have to create all my cube again because Revert is destoying all my structure of cube.
Why?
I understand that I have to refresh manually my cube, buy why I have to destroy my defined cube each time? Is there any way to prevent my structure of cube (set measures, rows, columns etc) from being destroyed and just refresh data when report parameters have been changed?

Last edited by Patryx (2019-08-27 22:03:26)

Offline

#2 2019-08-28 06:43:02

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Pivot mode in dynamic list -> how to refresh cube

Hi Patryx,

are you talking of a mondrian report or of a pivot report of a dynamic list ?

Regards,
Eduardo

Offline

#3 2019-08-28 06:58:08

Patryx
Member
Registered: 2019-03-25

Re: Pivot mode in dynamic list -> how to refresh cube

Hi Eduardo,
As I wrote in title of the post: Pivot mode in dynamic list ;-)

Last edited by Patryx (2019-08-28 06:58:26)

Offline

#4 2019-08-28 07:33:59

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Pivot mode in dynamic list -> how to refresh cube

Hi Patryx,

I see the problem and raised RS-3654 for this.

Regards,
Eduardo

Offline

#5 2019-08-29 11:57:30

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Pivot mode in dynamic list -> how to refresh cube

Hi Patryx,

just a quick information on this:
we are currently testing an approach to solve this problem. We will let you know if this works.

Regards,
Eduardo

Offline

#6 2019-08-29 16:58:21

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Pivot mode in dynamic list -> how to refresh cube

Hi Patryx,

we changed this behavior for the next 3.1.0 version. Pressing the green "run query" button now re-reads the parameter values.

Regards,
Eduardo

Offline

#7 2019-08-30 06:39:27

Patryx
Member
Registered: 2019-03-25

Re: Pivot mode in dynamic list -> how to refresh cube

Hi Eduardo,
Perfect. Is it possible to get such a version?
As maybe you know we are in the process of buying your products today, so it is quite important feature for our client. Recreating cubes is a big inconvenience for them.
I have installed your preview 3.1.0 (RS3.1.0-preview-6010-2019-08-13-12-16-09-reportserver-ee) with scripts.

Thanks in advance.

Regards,
Patryk

Offline

#8 2019-08-30 14:10:51

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Pivot mode in dynamic list -> how to refresh cube

Hi Patryx,

we just released the 3.1.0 BETA release. Please take a look here for details: https://forum.reportserver.net/viewtopic.php?id=1541

Best regards,
Eduardo

Offline

#9 2019-10-02 15:53:35

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Pivot mode in dynamic list -> how to refresh cube

Hi Patryx,

RS-3654 was fixed in the 3.1.0 version.

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB