7 Replies Latest reply: Sep 27, 2011 6:07 AM by Sunil Chauhan RSS

    How to find whether the fields has been used in the charts!

      Hi All

       

      How to find whether the field which is there load script is been used in any of the charts or not(In dimension/expression/variable). I don't want to open one by one chart and see are we using the particular field as it is time consuming job.

       

      Can some one please help me out with the best way to investigate whether we are using that field or not.

       

      Thanks

       

      Attitude

        • How to find whether the fields has been used in the charts!
          Anand Chouhan

          Hi,

           

          Thanks,Same thing i want to search if you got let me know about that.

           

          Regards

          Anand

          • How to find whether the fields has been used in the charts!
            Kaushik Solanki

            HI,

             

                Try this.

             

               

            tmpSOE:

            LOAD

              filepath()   as FileName,  

              SheetId   as ObjectId,

              'Sheet'   as SOE_Type,

                 Title   as Label 

            FROM C:\pqr.qvw  (XmlSimple, Table is [DocumentSummary/Sheet]);

             

            // Sheet Objects

            OUTER JOIN LOAD

               filepath()  as FileName, 

               REPLACE(ObjectId,'Document\','') as ObjectId,

                  Type   as SOE_Type,

                  Caption        as Label

            FROM C:\pqr.qvw  (XmlSimple, Table is [DocumentSummary/SheetObject]);

             

            //Expressions:

            OUTER JOIN LOAD

              filepath()   as FileName,  

              ObjectId,

              'Expression'   as SOE_Type,

                 Definition,

                 Label

            FROM C:\pqr.qvw  (XmlSimple, Table is [DocumentSummary/Expression]);

             

            //CalculatedDimension:

            OUTER JOIN LOAD

              filepath()   as FileName, 

              ObjectId,

              'Dimension'    as SOE_Type,

                 PseudoDef      as Definition,

                 Title          as Label

            FROM C:\pqr.qvw  (XmlSimple, Table is [DocumentSummary/Dimension]);

             

            //VariableDescription:

            OUTER JOIN LOAD

              filepath()   as FileName,  

              ObjectId,

              'Variable'     as SOE_Type,

              RawValue    as Definition,

              Name     as Label

            FROM C:\pqr.qvw  (XmlSimple, Table is [DocumentSummary/VariableDescription]);

             

            //Report:

            OUTER JOIN LOAD

              filepath()   as FileName,  

                 Id    as ObjectId,

                 'Report'  as SOE_Type,

              Name   as Label   

            FROM C:\pqr.qvw  (XmlSimple, Table is [DocumentSummary/Report])

            WHERE Id > '';

             

            //BookmarkItems:

            OUTER JOIN LOAD

              filepath()   as FileName, 

              BookmarkId  as ObjectId,

              'Bookmark Item' as SOE_Type,

                 BookmarkField   as Label

            FROM C:\pqr.qvw  (XmlSimple, Table is [DocumentSummary/BookmarkItems]);

             

            //Bookmark:

            OUTER JOIN LOAD

              filepath()   as FileName,  

              BookmarkId  as ObjectId,

              'Bookmark'   as SOE_Type,

                 Name   as Label

            FROM C:\pqr.qvw  (XmlSimple, Table is [DocumentSummary/Bookmark]);

             

            Hope this will solve many of your problems.

             

             

             

            Regards,

            Kaushik Solanki

            • How to find whether the fields has been used in the charts!
              Angus Monro

              There's a Find feature in Settings > Expression Overview that you can use for this.