Full Company vs Division When Section Access is Applied

[aveeeeeee7en]

Dear Community

I have a requirement to show Full Company vs Division Gender Bifurcation.

The problem I am facing is I have assigned Section Access on the Division field for some of users.

When a person opens Application, he only sees his Division Data, so how this is possible to show full company Data.

Is the below requirement possible when Section Access is Applied.  Need Suggestions???

Regards

Aviral Nag

[#2]

i have done a similar thing. Not sure if that is the best way. I had duplicate columns for all the measures in a different table which would not have the division name at all. so when you actually reduce the data this duplicate table won't reduce and you get the entire view of the data but with different column names. Then you use that data for comparison. Not an easy task i should tell you upfront.

This is primarily used for benchmarking and was worth the pain, Users simply loved to see how their division fares in overall scheme of things.

[SunilChauhan]

i thing you can provide hime all divisions access then he will have all company data.

as company data is link to Division.

if you provide 1 region then data related to that region will be visible. and full then full data

[aveeeeeee7en]

Any Suggestions????

[tresesco]

If you aggregate the data in the script, you could achieve that. For detailed help, provide a sample.

[aveeeeeee7en]

Tresesco Sir  thanks for the reply.

PFA.

[tresesco]

LOAD
          EmpCode,
         Sexx,          // renamed to avoid moderation delay
         EmpStatus,
         DIVISION
FROM
TestFile.qvd
(qvd);

LOAD  Sexx,
            Count( EmpCode) as AggrCount    
FROM TestFile.qvd (qvd) Group By Sexx;

Note: Use AggrCount field in the expression for referering  total count.

Aggreagate the count on sexx dimension like above and apply the section access thereafter, divisions would get the total even after that.

[aveeeeeee7en]

After assigning Section Access I am facing this Problem:

[aveeeeeee7en]

Not able to achieve the desired result.

[tresesco · Accepted solution]

Section Access;
Load * inline
[ACCESS,USERID,PASSWORD, DIVISION
ADMIN, Admin,Admin,
USER,AAAA,aaaa, AAAA
USER, BBBB, bbbb, BBBBB ];
Section Application;

LOAD Sex&EmpStatus,
  EmpCode,
    Sex,
    EmpStatus,
    DIVISION
FROM
TestFile.qvd
(qvd);

LOAD Sex&EmpStatus,
  Count(DISTINCT EmpCode) as AggrCount
   
FROM TestFile.qvd (qvd) Group By Sex, EmpStatus;

PFA. Changed the expression of the first chart.