Save Column Properties

Save the Column Properties as "System wide deault for a column" or "System wide deault for data type".

When you build a request, you can edit properties for a column to control the appearance and layout

of a column and its contents. By default, your selections for a column apply only to the current

request.

If your user ID has the appropriate permissions, you can save your selections as the system-wide

default settings to use every time that data from the column, or columns of this particular data type,

appear in results.

Step1: Login to Presentation services as Administrator(By default Administrator has this permission).

Step2: Select any column from any table.

Step3: Click on column properties button of the column. Then you will get the column properties  window. Here you select all the properties.

Step4: Now click on the save button.

Notice that two options are displaying.

If you select "as the system-wide default for <column name>"(in our case column name is "E05  Manager Name"), these format properties will be default for system wide for this column. That is these properties will be default for this column when you login as any user.

If you select "as the system-wide default for this data type", these format properties will be default for system wide for the this data type(In our case, String is the data type of this, so this property will be applied to all the columns having String as data type ). That is these properties will be default for this column when you login as any user.
Step5: select the first option ie. "as the system-wide default for  "E05  Manager Name", then click OK.Now click on Results tab.

Step6: Now click on Criteria tab and add the same column("D5 Employee"."E05  Manager Name") and one different column(in my case, "D5 Employee"."E03  Supervisor Name") and don't do any column  format changes.

Step7: Even If we login as diffenrent user, the same column format properties will be the default.
Now login as defferent user and select the above columns and display the result. Click on the Result tab.

Observe that the second column having the same column format properties as of first colomn but the third column having the different column properties. This is because of, the first and second column are same columns so the second column acquired the same format properties  of first column as the default format column properties.

If we select the second option ("as the system-wide default for this data type") then the format properties will reflect to all String type columns.

Select the second option and then click OK.



Now login as defferent user and select the String type column and display the result. We will get the same column format properties as the default properties.


Then click on the Result tab.

Observe that the third column also having the same column format properties even if we dint set the propertied explicitly for that column.

Using a Saved Oracle BI Request as a Filter

Any saved request that returns a column of values can be used to filter the selected column in your request.

Step1 : create a request with column(s) that will be used as a filter for any column of new request.

save the request.(In my case path : users/jaga/req_filter)

Step2 : Let us create a new request where we want to use previous request as filter for columns.
Add any column to the request, then click on the filter button.

         

Step3 : Next, click on then Advanced button and select "Filter based on results of another request" option.

Step4 : From the Relationship dropdown select the operator, then type/browse the path of the saved request which you want to use a filter for this column.

Step4 : Now we can select the any column of saved request (to be used as filter) using the "Use values in Column" dropdown.

If the saved request contains a matching column name, it appears in the Use Values in Column
drop-down list. If you want to use another column, select it instead.
Then Click OK . Now you can notice that the filter have been added to the request.

Now click on the "Results" tab to see results.
Comparison of result of new request and saved request.
Result of saved reuest :

Result of New Request :

We can see that the "E05 Manager Name" column is filtered by the "E05 Manager Name" column of saved request.