Skip to Content

This document is prepared based on SAP HANA Version SPS05 Revision 47.


In the Navigator panel of HANA studio, when you expand Catalog folder you may see the huge list of Schemas and similarly a huge list of packages for Content folder, a huge list of Column views under _SYS_BIC schema.


Whenever an information view (Attribute view or Analytic view or Calculation view) is activated, a copy of information view will be placed in Column view of _SYS_BIC schema and there is a good scope to see a big list in this column view.

(For better visibility I pasted column views side by side)

Screen01.JPG

When we want to view a particular column view then we need to scroll down till we find our column view and this is somewhat we does not like to scroll always. So we have the feature to apply Filter on Column view to see only the view which we want to see. In this example say “srk/DT_EMPLOYEE/RV“.


Steps to apply filter:


Step 1: Right click on column view and select “Filter” as shown below.

                       Screen02.JPG

Step 2: Enter the name of the column (You can enter partial name or full name). If it is partial name then you will see the column view names containing the partial name we given. In this example I am giving full name.

                     Screen03.JPG

Step 3: Now we can see the only column view name from a bunch of list. Also you see the name of our filter beside the Column Views folder.

                  Screen04.JPG

If you want to see another column view just repeat the above process from Step 1 to Step 3. In this example I want to see all the column views containing the word “srk”. So again if we apply filter then previous filter will be overridden with new filter.

                   Screen05.JPG

Now you can see our new filter name beside the Column Views folder and it contains around 15 column views matching the word “srk” as shown below.


To remove the filter, right click the Column view folder and again select the filter name “srk”.

                  Screen06.JPG

This will remove our filter and again you can see a bulk list of column views.


We can also perform filter on Catalog folder for Schema, Public Synonyms, Functions, Indexes, Procedures, Sequences, Synonyms, Tables, Triggers, and Views.

We can apply filter on Users and Roles under Security folder.

We can apply filter packages under Content folder.

We can also filter objects under a particular package.

That’s it, we are done with with Applying and removing Filters

Thank You.

Raj Kumar

To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

  1. Ravindra Channe

    Hi,

    There is also a better way of filtering in SP05. You can directly filter for Tables, Models, Column views in one go at the top level filter box. I know it is on Studio Revision 52, not sure about the earlier versions.

    Regards,

    Ravi

    (0) 
    1. Patrick Bachmann

      Ravi, I have the search option in version 48 but what’s cool about the filter is it retains this filter when you close Studio and come back.  Also you can easily toggle the filter back on and off afterwards so it is still useful I think even with the search feature.  Thanks Raj.

      -Patrick

      (0) 

Leave a Reply