1 Reply Latest reply: Feb 22, 2017 7:32 AM by sasi k RSS

    Dimension problem - is there a solution?

    Friedrich Hofmann

      Hi,

       

      I have an app where I link two tables - delivery_plans and packing_plans - to determine how much packing_material will be needed to fulfill what is in the delivery_plans for the coming weeks.

      There are several dimensions to both tables.

      So far, so good. When I have all necessary dimensions active, all is well.

      What I'd like to implement for the user, however, is the possibility to activate or deactivate the dimensions (except one, of course, there has to be some dimension).

      <=> Then I run into problems because in certain circumstances, figures cannot be aggregated correctly, so I have the dash in my chart in that case and the figures are incorrect.

      Is there a possibility to check if, somewhere in the chart acc. to the currently active selections, there is the dash (there are different values)? I'd like to implement an alert.

      It should be possible to find a solution - there has to be a way to correctly aggregate everything - but there's no time and it's not that important.

      Thanks a lot!

      Best regards,

       

      DataNibbler

        • Re: Dimension problem - is there a solution?
          sasi k

          HI,

          If  there are less number of dimensions for user selection then you can go for Flags in script

          some thing like below

           

          Load * INLINE

          DIM,Dim1flag,dim2flag,dim3flag

          Dim1,1,0,0

          Dim2,0,1,0

          Dim3,0,0,1

          ];

           

          Use Dimension--> Enable Conditional-->Dim1flag=1 or Dim2flag=1 for Dim2

           

          Exp: sum(Aggr(sum(Sales),Dim1))*Dim1flag+ sum(Aggr(sum(Sales),Dim2))*Dim2flag+

                   sum(Aggr(sum(Sales),Dim3))*Dim3flag


          Always one dimension should be selected.