9 Replies Latest reply: Apr 25, 2014 7:56 AM by Sudeep Mahapatra RSS

    Issue in QV reload

    Vidhya Vk

      Hi all,

      I am facing the following issue in a application.

      I reload a application and I get my salesvalue as, say for example 9 billion.

      Then I save and close the application.When I open the same application, I get salesnumbers as 7 billion.

      What does this mean?

      Kindly help me on this issue.

      Thanks in advance,

      Regards,

      Vidhya

        • Re: Issue in QV reload
          Felim Shanaghy

          reloading through desktop? have you got section access applied?

           

          It sounds like you dont have access to all the data, as section access is applied on open not after reload

            • Re: Issue in QV reload
              Vidhya Vk

              I did a reload in server, yes section access is applied in the application.

              I have included Link Table in the application,

              Will this happen anytime because of any issue in LinkTable?

               

              Thanks & Regards,

              Vidhya

                • Re: Issue in QV reload
                  Sudeep Mahapatra

                  I do not think link table is causing the problem because even after the link table you are able to see 9bn when you open the document and save it.

                  I think now that section access might have impact on it.

                  One quick question. When you said that "I reload a application and I get my salesvalue as, say for example 9 billion."

                  Can you pls tell whether section access was applied that time or it is just a full reload in your local system?

                    • Re: Issue in QV reload
                      Vidhya Vk

                      Hi Sudeep,

                      I implemented Link Table concept in my application, then gave a reload, after reload, 9 billion bookings is seen, I saved and closed the application, when I open the closed application again, I am getting 7 billion as bookings, In both cases, section access was applied.

                      Thanks,

                      Vidhya

                        • Re: Issue in QV reload
                          Sudeep Mahapatra

                          Even if you have section access applied but you reload the document then the whole data gets reloaded ignoring the section access. That's the reason we add Publisher Functional ID in the section access table as Admin so that the reload will be full data.

                          Section Access is applied when you open the document. Remember one thing that Section Access ignores the null entries of the Field used in the section access table.

                          So can you please make sure that the field name based on which you are reducing data from the document does not have null values.

                          Can you please post screenshot of your Section Access Table?

                  • Re: Issue in QV reload
                    Sudeep Mahapatra

                    Do you have any document level or sheet level trigger set and as a result some filter selection is occurring and the values being shown as 7bn?

                    In that case when you reopen the file then look at the current selection box just to make sure if it is not the impact of any selections.

                    It would be good if you can attach the file for verification.

                    • Re: Issue in QV reload

                      Hi Vidhya,

                       

                      What is the source for your data and is the source data residing on your server?

                      Also is there a reload job running on your server for this?

                       

                      Thanks

                      Sabal

                      • Re: Issue in QV reload
                        Vidhya Vk

                        Datasource is in the server only, there is no job running in the server for this.

                        Section access is applied in the application, both before and after reload, current selections are the same.

                        Thanks & Regards,

                        Vidhya

                        • Re: Issue in QV reload
                          Mark Munich

                          Just check out if there is a trigger or filter applied on any of the dimensions which is influencing your revenue.