Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Community,
I have to reduce data using section action.
this is my section action file,... sheet wise everyone full action,
NTNAME | ACCESS | CLIENT |
US\Av6 | * | Ashok Kumar |
US\CharyN | * | Narasimha Chary |
US\Sam1 | * | Sampath |
when CLIENT login to application, only they have to see their subclients, Suppose Ashok Kumar logins to application he have to see his SubClients. it should be first 4 records.
Table:
CLIENT | SubClient | Amount |
Ashok Kumar | Nokia1 | 2500 |
Ashok Kumar | Nokia2 | 520 |
Ashok Kumar | Nokia3 | 680 |
Ashok Kumar | Nokia4 | 1200 |
Narasimha Chary | Samsung1 | 8900 |
Narasimha Chary | samsung2 | 9000 |
Narasimha Chary | samsung3 | 12000 |
Sampath | LG1 | 8000 |
Sampath | LG2 | 2900 |
Sampath | LG3 | 5600 |
Thanks in Advance..
Hi,
Please refer to the attached sample app, actually you no need to keep user information fact table. In general it should work by defining it at section access level. Thanks
ACCESS | USERID | PASSWORD | CLIENT |
USER | USER | USER | * |
ADMIN | ADMIN | ADMIN | * |
USER | ASHOK | ASHOK | NOKIA1 |
USER | ASHOK | ASHOK | NOKIA2 |
USER | ASHOK | ASHOK | NOKIA3 |
USER | ASHOK | ASHOK | NOKIA4 |
USER | NARASIMHA | NARASIMHA | SAMSUNG1 |
USER | NARASIMHA | NARASIMHA | SAMSUNG2 |
USER | NARASIMHA | NARASIMHA | SAMSUNG3 |
USER | SAMPATH | SAMPATH | LG1 |
USER | SAMPATH | SAMPATH | LG2 |
USER | SAMPATH | SAMPATH | LG3 |
also remember to do below steps
1) Section access script always keep in the very first tab
2) Define Section Access on document level “Settings” -> “Document Properties” -> “Opening”
“Initial Data Reduction Based on Section Access”
Tick the checkbox to enable section access in the document.
3) “Settings” -> “Document Properties” ->"Security --> please un check - reload & check override admin security option (its safe side keep admin full permission and it's used to troubleshoot the application if anything goes wrong)
4) try to make backup of you application before doing any changes on section (once it's lost its difficult to recover it)
5) also if you make any changes on the document (Section access), it will reflect after re-open the document
FYI, step 2 & 3
also you can check
Hi Paul,
First Step: should be your service should be added in section access with ACCESS type ADMIN
Like,
Star is *;
NTNAME ACCESS CLIENT
ServiceId ADMIN *
YourId ADMIN *
A1 USER A11
B1 USER B11
C1 USER C11
Second Step: Prepare your bridge table with client and subclient relation
CLIENT | SubClient | Amount |
A11 | Nokia1 | 2500 |
A11 | Nokia2 | 520 |
A11 | Nokia3 | 680 |
A11 | Nokia4 | 1200 |
B11 | Samsung1 | 8900 |
B11 | samsung2 | 9000 |
B11 | samsung3 | 12000 |
C11 | LG1 | 8000 |
C11 | LG2 | 2900 |
C11 | LG3 | 5600 |
Third Step: Check option inside your qvw. Document Properties - > Opening -> Initial Data Reduction and Strict Exclusion
Thanks
Ravi Balar