Completed
Last Updated: 10 Jan 2022 14:52 by ADMIN
Release LIB 2021.3.1025 (25 Oct 2021)
LindenauAtSOG
Created on: 29 Jul 2021 11:25
Category: PivotGrid
Type: Bug Report
4
Sets appear too often
Bug can be reproduced in PivotGrid => Olap Support in demo application.
Under all main categories in the designer, there is a folder called "Sets" that has the exact same content.

It either is mistakingly placed under each "category" or should be something that sits on top of them in a more global fashion.

7 comments
ADMIN
Ivan Petrov
Posted on: 10 Jan 2022 14:52

Hello Christian,

After some more digging, I found there is a way to extract the set folder name from the metadata we receive from the server. I have logged a separate item in our feedback portal for it. You can vote, comment, and track its progress there.

Thank you for the additional information you provided it was very helpful during my research. I have also updated your Telerik Points.

Regards,
Ivan Petrov
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

LindenauAtSOG
Posted on: 03 Jan 2022 15:13
Hello Ivan,

I need to clarify my previous comment.

The names come from the defined MDX-Queries. Some explanation on this topic can be found here
https://www.mssqltips.com/sqlservertutorial/2014/developing-named-sets/

Example:

CREATE DYNAMIC SET CURRENTCUBE.[Filter Jahr (letzte 2)]
AS LASTPERIODS
(2,
Exists
(
[Zeit].[Kalenderjahr].[Kalenderjahr Jahr].MEMBERS,
FILTER
(
[Zeit].[Kalenderjahr Monat].Members AS Help,
Help.Current.Properties("Aktuell") = "1"
)
).Item(0)
), DISPLAY_FOLDER = 'Filter';
LindenauAtSOG
Posted on: 03 Jan 2022 14:41
Hello Ivan,

there is a "DispalyFolder" setting, in the SSAS backend, that should be used in this case.

There is a few more settings 
Bild


But I couldn't find any that regards the order. But alphabetically seems natural to me.
ADMIN
Ivan Petrov
Posted on: 06 Dec 2021 15:26

Hello Christian,

Thank you for the update.

Looking at the source code the "Sets" term is something we have introduced internally to deal with this group of items. I think the metadata generated that holds these sets of nodes does not provide a name for them. My guess is that your sass backend might be inferring this information from the items inside the node. Could you give me some more examples of where the sass backend differs from our pivot component? What I'm looking for is a logical connection between the name of these folders and the nodes they contain. Another thing that I've noticed is that the nodes on your backend are sorted alphabetically. Is this an important thing to have? 

Looking forward to your reply.

Regards,
Ivan Petrov
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

LindenauAtSOG
Posted on: 01 Dec 2021 11:58

Hello Dinko,

we tested the corrected version and it does appear only once now.
However, the category is still incorrect.

first picture is how it looks on ssas backend,
second is how it looks in the control

 

ADMIN
Dinko
Posted on: 12 Aug 2021 13:02

Hi Christian,

Thank you for your patience.

I have performed several tests and you are right that the sets are duplicates for each dimension. Nevertheless, when you select a set it will be select across all dimensions. They should be filtered for the specific category. I have performed the same set-up in Excel, and the sets aren't duplicate. We could improve this functionality in our RadPivotGrid control. I am changing the status of the item to Unplanned. When we add this item to our planning, we will update the status so that you can get notified. 

I have updated your Telerik Points for bringing this to our attention.

Regards,
Dinko
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

ADMIN
Dinko
Posted on: 04 Aug 2021 09:41

Hi Christian,

Thank you for the provided image.

You are right that in the Sets section the children are the same for each category. At this moment, I can't confirm that if this is the correct behavior or not. I will need more time to debug the source code. I will contact you again as soon as I have more information regarding the reported behavior.

Regards,
Dinko
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.