6 Replies Latest reply: Feb 4, 2012 8:03 PM by Dwi Sulistiyo RSS

    Section Access - QVD

      I set up a simple section access for security in my app.  I set it up for ADMIN and USER, NTNAME, and set 1 field to restrict the data to.  When I set up the list of usernames and rights via an external spreadsheet it works great.  But, we also have a process where we can create a Google Doc spreadsheet, and those get turned into QVD's (this way others in the business can manage their data).  Now, when I try and set my app to pull my section access rights from the QVD, my app will not pull data from it, it fails out.  Is this just the nature of QV oris there another way?  Thanks,

        • Re: Section Access - QVD
          Jakob Fabian

          There should not be a problem creating a QVD from a Google Doc Spreadsheet. Something else must be up.

          Is your google spreadsheet formatted in the right manner for Section Access?

          • Section Access - QVD

            hi,

             

            Use resident from you qvd data, please see below

            Sec:

            LOAD ACCESS,

                 USERID,

                 PASSWORD,

                 SERIAL,

                 NTNAME

            FROM

            Sec.qvd

            (qvd);

             

            Section Access;

             

            Load

                 ACCESS,

                 USERID,

                 PASSWORD,

                 SERIAL,

                 NTNAME

            Resident Sec;

             

            Section Application;

             

            drop table Sec;

              • Section Access - QVD

                Thank you.  Also, my understanding is, under the document properties, security tab, I can unselect Allow Export and this will prevent USERS for exporting data.  But when I hit apply, the XL icon on my charts disappears and I am the ADMIN.  Any thoughts here?  Also, in my section application section of my section access, I do not list out users who are ADMIN as when I log in, I can still see all of the data, so i assumed I only have to spell out the access for USERS.  Could this have anything to do with allowing export?  Thanks again,

                  • Section Access - QVD

                    But when I hit apply, the XL icon on my charts disappears and I am the ADMIN.  Any thoughts here? - you need to select also "Admin Override Security".

                    Also consider about the setting in yours management console. Go to tab "Documents" and choose you documents, in your right go to tab "Server" and choose to section "Availability". take a look at Print and Export to Excel option.

                     

                    In section application mostly only will related to data reduction or selection at the first.

                      • Section Access - QVD

                        Thank you again, I hate it when I miss something right in front of me. :-)  With my section access set to limit the user to one value in the field, (field = Division, User can only see where Division = 50).  Can set acces be expanded to also include an OMIT field after this?  For example, we have Sales Org = 1100, Division 50 that all can see, but then I have Sales Org 2000, Division 50.  I want the user to see all of Division 50 expect for Sales Org 2000, Divison 50.  We have many Divisons under Sales Org 1100 , not just Division 50.  Thanks.

                          • Re: Section Access - QVD

                            hmm..u should find how to filter the value that came only from Sales Org 2000 in division 50 and use that in yours section application.

                            Might be like this

                             

                            Sales Org, Division, SalesRepId

                            1100, 50, 1

                            1100, 40,

                            2000, 50, 2

                             

                            need more analysis on the data itself