Using Client Cube Engine with multiple dimensions

[Edward]

Sample Class (one of the many I have tried) and sample data is at the bottom.

When using the PivotGrid, I could use a little assistance on how to get the row dimensions to properly travel my hierarchy properly.
I am using the following Hierarchy. 

Activities (A)
      Disciplines  (D)
           Systems (S)
                 Tasks (T)

I have been able to get it to work with just one Activities and Disciplines, but I cannot get it working with all 4 items.  I have attached my last attempt, which was creating the class with the ID/Name pair for each of the 4 items, and then filling the records up, but it still keeps choking at the 3rd level.  I have tried nesting them as well, when worked perfectly for the treeview control, but completely blew up on the PivotGrid.

So, what I am trying to accomplish is have a pivot grid that will be as follows when fully expanded.  

A1
     D1
         S1
              T1
              T2
         S2
              T3
     D2
         S3
              T3
A2 ....etc

 

Thanks in advance for your assistance!
Ed

 

 

    public class PhasePivotVM
    {
        public Single Score { get; set; }

        public int ActivityID { get; set; }
        public ActivityTypeVM ActivityTypes { get; set; }

        public int DisciplineID { get; set; }
        public DisciplineTypeVM DisciplineTypes { get; set; }

        public int SystemID { get; set; }
        public SystemTypeVM SystemTypes { get; set; }

        public int TaskID { get; set; }
        public TaskTypeVM TaskTypes { get; set; }

        public PhasePivotVM()
        {
            ActivityTypes=new ActivityTypeVM();
            DisciplineTypes = new DisciplineTypeVM();
            SystemTypes = new SystemTypeVM();
            TaskTypes = new TaskTypeVM();
        }
    }
    public class ActivityTypeVM
    {
        public int? ActivityID { get; set; }
        public string ActivityName { get; set; }
    }
    public class DisciplineTypeVM
    {
        public int? DisciplineID { get; set; }
        public string DisciplineName { get; set; }
    }
    public class SystemTypeVM
    {
        public int? SystemID { get; set; }
        public string SystemName { get; set; }
    }
    public class TaskTypeVM
    {
        public int? TaskID { get; set; }
        public string TaskName { get; set; }
    }

ActivityID DisciplineID SystemID TaskID ItemScore  ItemName
4              NULL           NULL        NULL  100             *Exist but are all hidden for privacy*
4              13                NULL        NULL  100
4              13               40              NULL  100
4              13               40              188     100
4              13               40              278     100
4              13               40              279     100
5              NULL           NULL        NULL  100             
5              23                NULL        NULL  100
5              23               41              NULL  100
5              23               41              414      98

[Edward]

Never mind, solved the rows...now I'm missing my measures when I added a column.  Wooot!  Still progress, so I'm good.

[Viktor Tachev]

Hi Edward,

I am glad that you have the required functionality up and running. 

What I would like is to touch upon the client-side cube. Please have in mind that with this configuration it is recommended to work with relatively small amount of data. The reason behind this is that data is processed on the client and that can produce slow performance and hinder the user experience when having large data. If you would like more information on the matter please check out the article below:

• https://docs.telerik.com/kendo-ui/controls/data-management/pivotgrid/overview#binding-to-large-flat-data

In case you have additional queries on our components do not hesitate to contact us again. It would be great if you can also send a small runnable project or a dojo sample where the behavior you are seeing is replicated. This will enable us to examine the issue locally and look for its cause.


Regards,
Viktor Tachev
Progress Telerik

[Edward]

Viktor,

Thank you for your reply.  This dataset is less than 2000 records with the partial view being shown in the tabstrip to make it easier on the users.  I have to hide the configurator, and I also have to hide all the headers to remove items.  

That is what I'm working on now, is changing the classes try and hide all of the total columns and footers.

Again, thank you for responding.  Keep up the good work over there.