3 Replies Latest reply: Jun 14, 2011 4:54 AM by mady mama RSS

    Ignore fields from a Dimension?

      Hello I have a dimension called dahboarfieldname which I am getting from a standard Monthly.QVS(Script). My question is I have some fields within the dashboardfilename table from which I want to drop the fields like Trading Income, Legal Docs, Clearing. Whats the best way to do this as I cannot import the full tables and then comment these fields out? Also can this be achieved with Set Analysis on a Pivot?

       

      Thanks in advance

       

      Mady

        • Ignore fields from a Dimension?

          Adding to the above question I have the connection like this. And from here comes the table Dashboard, in which I have a field Dashboardfilename in there are all these fields as mentioned above...

           

          CONNECT TO $(StrConnMonthly);

          $(Include=scriptfiles\data_monthly.qvs)

           

           

           

          hope this helps, thanks again

           

          Mady

            • Re: Ignore fields from a Dimension?

              Hi,
              This may be one way to do this...


              Monthly_TMP:

              CONNECT TO $(StrConnMonthly);

              $(Include=scriptfiles\data_monthly.qvs)

               

              Monthly:

              LOAD *

              RESIDENT Monthly_TMP;

               

              Drop Fields [Trading Income], [Legal Docs], Clearing;

              Drop Table Monthly_TMP;

               

              /@Ungvall

                • Ignore fields from a Dimension?

                  Hello Thankyou for the quick reply, but i have an error as Table not found Monthly and moreover I was wondering if this looks into the Dashboard Table, Dashboardnamefield Field and the data within there Trading Income..??

                   

                  Just wondering why is it that hard to do it in QV or if i am unable to get to it??

                   

                  Anymore help please?

                  Thanks in advance