Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  workspace "summarize all" function with set of members with per-user authorization

    Posted Wed July 27, 2022 12:14 PM
    I created a view, where in the rows I expose the members at level zero, then I used the workspace function of "summarize" to create a total, dynamic based on the displayed members. my problem is: when connecting a user who is only allowed to see some members, the summarize function does the total on all members and not just on those displayed. is it an error of the summarize function or is there some other way to get the dynamic total on displayed members based on permissions? thank you
    example 

    |member|autorization|
    --------------------
    |AGE1 |Group1 |
    |AGE2 |Group1 |
    |AGE3 |Group2 |
    |AGE4 |Group2 |

    view created by admin
    |member | SALES |
    ----------------------
    |AGE1      |10 |
    |AGE2      |10 |
    |AGE3      |10 |
    |AGE4      |10 |
    ----------------------
    |Calc Total |40 | the Calc total use the workspace function summarize aggregate


    login with user of Group1
    |member | SALES |
    ----------------------
    |AGE1      |10 |
    |AGE2      |10 |
    ----------------------
    |Calc Total |40 | the Calc total use the workspace function summarize aggregate

    I expect      20


    ------------------------------
    Massimo
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: workspace "summarize all" function with set of members with per-user authorization

    Posted Thu August 11, 2022 12:38 PM
    Hi Massimo,

    I use the summarize function in PAW and it sums only the visible members. I am running PAW 2.0.78.
    Please see the screenshots from my laptop below. If your setup is different, please let me know and I will try recreate the issue. 



    Best regards,
    Kong

    ------------------------------
    Kong Intrasinghathong
    Master Consultant
    QueBIT Consulting

    Analyze. Plan. Achieve.
    https://quebit.com
    ------------------------------

    Original Message


  • 3.  RE: workspace "summarize all" function with set of members with per-user authorization

    Posted Mon August 22, 2022 05:42 AM
    Hi Kong,
    thanks for help me.
    I have the problem with version 72 and 77.
    I created a view with the set at level 0, then I used the sum function,
    the value that the function returns is always the total of all members, not just those displayed due to user permissions.
    the summarize function works only if I select some member and click Keep.

    Massimo
    --







    Original Message


  • 4.  RE: workspace "summarize all" function with set of members with per-user authorization

    Posted Mon August 22, 2022 12:42 PM
    Hi Massimo,
    There are two types of sum functions.  One is if you select members and then create calculation and then sum.  This creates a hard coded calculation using the base ID (not an alias) and will return the same total all the time.  The other is if you select an entire dimension in a row or column using the double lines and then right click and choose subset calculation.
    Select All Elements of a Dim in cube viewer
      This calculations lets you choose a subset, and should return different results for the total based on what the user can see in the set.

    Did the help?

    ------------------------------
    Scott Brown
    ------------------------------

    Original Message


  • 5.  RE: workspace "summarize all" function with set of members with per-user authorization

    Posted Wed August 24, 2022 08:38 AM
    Hello Scott,
    thanks, 
    I tried to do what you described, in my environment it doesn't work, using the subset calculation function and selecting "all members", it always gives me the total of the whole dimension and not just what the user sees.

    Massimo




    Original Message


  • 6.  RE: workspace "summarize all" function with set of members with per-user authorization

    Posted Mon September 12, 2022 05:54 AM
    Hello Massimo,

    Maybe a bit late but...
    I think there is a difference of behavior between 
    - "sum" function (which takes into account members' permissions)
    - and the aggregate function (which aggregates all members regardless of security).
    Regards,

    ------------------------------
    Florence Mougnaud
    ------------------------------

    Original Message


  • 7.  RE: workspace "summarize all" function with set of members with per-user authorization

    Posted Tue September 13, 2022 01:14 AM
    Hi Massimo,

    I agree with Scott Brown and Florence Mougnaud that you should use "Summarize all..." (instead of "Create calculation...") with "Sum" (instead of "Aggregate") to get the sum of the visible elements. I think "Subset calculation" with "Sum" should work too.

    Best regards,
    Kong

    ------------------------------
    Kong Intrasinghathong
    Master Consultant
    QueBIT Consulting

    Analyze. Plan. Achieve.
    https://quebit.com
    ------------------------------

    Original Message


  • 8.  RE: workspace "summarize all" function with set of members with per-user authorization

    Posted Tue September 13, 2022 03:07 AM
    Hello,
    thanks Kong and Florence, for the answer,
    the problem of the sum is this: makes the sum of the calculated fields eg the variance.
    if in my visualization I have the data of cy and py with the variance, I cannot use the sum, but I have to use aggregate
    Massimo






    Original Message


Related Content