Clean default dashboard styles with CSS

How to remove bevels, spaces and box shadows from OBIEE Dashboard?

By default, dashboard sections are visually separated from each other using spaces, borders, bevels and box shadows. Also the default color of dashboard background is light blue. We may want to remove it to get a cleaner dashboard display.

RemoveDashboardStyleFormatting1

Continue reading

Enable word wrap in Toad

How to enable word wrap in Toad?

To do that we will need to set the right margin position and enable the word wrap in Toad options.

Go to View / Toad Options:

ToadMenu

First go to Editor / Display to modify the position of right margin. Set Visible right margin to the position you want.

WordWrapToad7

Select Editor / Behavior and check the Word wrap option:

WordWrapToad6

Query that was going outside the margin before the changes:WordWrapToad1

After changes are applied, query is wrapped to the right margin:WordWrapToad2

See the post on how to enable the word wrap feature in Oracle SQL Developer.

Enable word wrap in Oracle SQL Developer

How to enable word wrap in Oracle SQL Developer?

Actually there is no such option in Oracle SQL Developer as of version 4.02 (this may be changed in further releases). To enable similar feature you’ll need to set a line break at some line width and format the text using CTRL + F7 key combination. Here’s how to do it:

To set maximum line width in characters go to Tools / Preferences:

WordWraoSQLDeveloper

Choose Database / SQL Formatter / Oracle Formatting. Choose a profile to edit (default is Old Preferences) and click Edit:

WordWrapSQLDeveloper2

Set Max Line Width up to as many characters you want (here 80):

WordWrapSQLDeveloper1

Query is still unformatted and some lines are outside the grey right margin line set at 80 characters:

WordWrapSQLDeveloper3

Press CTRL and F7 to format the query. In result the text will be wrapped to the right margin:

WordWrapSQLDeveloper4

Note that as of Oracle SQL Developer 4.02 the right margin line will be always set at 80 characters line width, even if you change that. So if you set Max Line Width at more than 80, the query will be formatted and wrapped up to that width, but the right margin line will be visible after 80 characters.

See the post on how to enable the word wrap feature in Toad.

Hide dashboard objects in OBIEE

How to hide a column or section from the dashboard display?

This workaround allows you to embed dashboard objects that are hidden from the view. Using this property you can hide Dashboard Column, Section or Alert Section objects. To hide particular reports or prompt you need to put them inside the hidden column or section.

We will need to use CSS formating to hide the dashboard elements. First, go to the top right corner of the column or section you want to hide and click on Format Section (or Format Column):

HideDashboardObjectsOBIEE1

Click on Custom CSS Style Options (HTML Only) and check Use Custom CSS Style.HideDashboardObjectsOBIEE2

In the text box put:

display: none;

The element with this property won’t be displayed on the dashboard. Note that this affects only the display of the dashboard, if you export the dashboard contents to a PDF the objects hidden with the CSS formatting will be visible.

Auto replace shortcuts in Oracle SQL Developer

How to enable auto replace shortcuts in Oracle SQL Developer?

In the Auto replace shortcuts in Toad post I showed you how to add auto-replace shortcuts in a Toad client. You can acheive the same in Oracle SQL Developer – here that feature is called SQL Editor Code Templates.

SQLDeveloper_Auto_replace

How to add a code template shortcut in SQL Developer?

First, go to Tools / Preferences:

SQLDeveloper_Auto_replace

Choose Database / SQL Editor Code Templates and click on Add Template button. For example add these two code templates:

saf - SELECT * FROM 
scaf - SELECT COUNT(1) FROM

Now to use the auto replace code template type the shortcut and press CTRL and SPACEBAR keys. Shortcut will be replaced with a pre-defined statement.

Open previous versions of objects in Informatica PowerCenter

With versioning control, Informatica PowerCenter stores the previous versions of objects inside them. You can open in workspace any of the previous versions. To do that right-click on the object and select Versioning / View History:

OpenPreviousVersionsofObjectsinInformatica2

Now you can see the history of all versioned changes with their dates, users, and comments. Select the version you want to preview with right-click and choose Open in Workspace:

OpenPreviousVersionsofObjectsinInformatica5

Now the session is opened in the workspace (notice the (v2) prefix that indicates the version):

OpenPreviousVersionsofObjectsinInformatica4

You can do that as well with other objects in Workflow Manager and Workflow Designer.  Objects from versioning history will have the prefixes with the version number:

OpenPreviousVersionsofObjectsinInformatica3