Completed
Last Updated: 13 Apr 2022 09:17 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.

12 comments
ADMIN
Ivan Petrov
Posted on: 13 Apr 2022 09:17

Hi Christian,

Thank you for your patience. We finally found out what was going on. I feel a bit embarrassed when these things happen but the reason the named folder sets did not appear is that we implemented them in the Xmla data provider and missed adding them to the Adomd one. It took us some time to realize we were not using the same setup as you, and why it was working on our end and not on yours. The Adomd implementation is checked-in and ready for our QAs to test it. It will most probably be included in our next week's LIB. 

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.

ADMIN
Ivan Petrov
Posted on: 23 Mar 2022 16:07

Hi Christian,

The feedback item was intentionally left in the "In Development" state. We wanted to double-check it is working on your end as well. It turns out we had a good hunch it might not be resolved 100%. We are actively researching why it is not working in all scenarios, and I will update you once we have more info.

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: 17 Mar 2022 09:00
It seems the ticket that was created for it is still in development.
Maybe we confused a few things here?

https://feedback.telerik.com/wpf/1548823-pivot-use-the-named-sets-metadata-to-place-them-in-a-correctly-named-folder
LindenauAtSOG
Posted on: 17 Mar 2022 08:09
Hi Ivan,

unfortunately it does not seem to work. Do I need to adjust anything in Code, I assumed it would work automatically?
ADMIN
Ivan Petrov
Posted on: 24 Feb 2022 09:32

Hi Christian,

I am happy to inform you that we have introduced the display folder for named sets in our pivot component. We will be happy to hear your thoughts on it. You can find it in our latest Service Pack that was released yesterday.

Looking forward to your reply.

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/.

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.