OBIEE10G & 11G Knowledge Sharing

Stopping and Starting OBIEE Services in linux

STOP OBIEE Services:

1. Shutdown OPMN Components

Oracle Process Manager should be used to shutdown all system components.

Go to> /u01/app/Middleware/instances/instance1/bin

cd /u01/app/Middleware/instances/instance1/bin

./opmnctl stopall

2.Shutdown Managed Server

Go to > /u01/app/Middleware/user_projects/domains/bifoundation_domain/bin

cd /u01/app/Middleware/user_projects/domains/bifoundation_domain/bin

./stopManagedWebLogic.sh bi_server1 t3://obie.new.com:7001 weblogic weblogic

Verify that the Managed Server has shut down completely with ps -ef | grep bi_server1.

3. Shutdown Node Manager

There should be a single Node Manager for the machine. Shut it down with the command below.

ps -ef | grep Node | grep nodemanager | grep -v grep | cut -c10-15

kill -9 ####

4. Shutdown Admin Server

There should be a single Node Manager for the machine. Shut it down with the command below.

Go to> /u01/app/Middleware/user_projects/domains/bifoundation_domain/bin

./stopWebLogic.sh weblogic weblogic t3://obie.new.com:7001

Verify that the Managed Server has shut down completely with ps -ef | grep AdminServer.

START OBIEE SERVICES:

1. Start Admin Server

cd /u01pt/app/Middleware/user_projects/domains/bifoundation_domain/bin

weblogic ./startWebLogic.sh -Dweblogic.management.username= weblogic Dweblogic.management.password=weblogic

tail -f weblogic.out

Weblogic.out is log file which logs the running status

After issuing the start command we tail the log until we see the message below, indicating that the server has started successfully.

StartNode Manager

cd /u01/app/Middleware/wlserver_10.3/server/bin

nodemanager ./startNodeManager.sh > nodemanager.out &

tail -f nodemanager.out

nodemanager.out is log file which logs the running status

After issuing the start command we tail the log until we see the message below, indicating that the server has started successfully.

3. Start Managed Server

By default there should be one managed server, bi_server1 that we will start up. At this point you should start any other Managed Servers in this WebLogic domain.

cd /u01/app/Middleware/wlserver_10.3/common/bin

./commEnv.sh

cd / u01/app/Middleware /user_projects/domains/bifoundation_domain/bin

./setDomainEnv.sh

weblogic ./startManagedWebLogic.sh bi_server1 t3://machine:7001 > bis1_startup.log &

tail weblogic.out

Weblogic.out is log file which logs the running status

After issuing the start command we tail the log until we see the message below, indicating that the server has started successfully. Server started in RUNNING mode

4. Startup OPMN Components

Oracle Process Manager should be used to shutdown all system components.

cd /u01/app/Middleware/instances/instance1/bin

./opmnctl startall

./opmnctl status

Now you can login to console and verify the status of the running servers.

Hope it Helps !!

Thanks,

Shanmugha Bharathy G B

Downgrading OBIEE RPD from 11.1.1.6 to 11.1.1.5 Version

"Downgrading OBIEE RPD from 11.1.1.6 to 11.1.1.5 Version"

Repository downgrade utility nqgenoldverrpd.exe is used to downgrade OBIEE RPD versions.
This utility was present in the 10.1.3.2.1 version of OBIEE but was removed in the later releases.

Note:

Using this Utility you cannot downgrade the RPD from 11g to 10g version. You can downgrade from one version to another 11g Versions.

Physical location of the nqgenoldverrpd.exe file will be
1 ) If you are using Admin tool on your system , the directory path will be

<BI_HOME>\bifoundation\server\bin

2) If you are using Admin client, the directory path will be

C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client11.1.1.6\oraclebi\orahome\bifoundation\server\bin

Downgrading:

1. Goto>StartMenu>All Programs>Oracle Business Intelligence Enterprise Edition
2. Select BI Command Prompt
3. Syntax for Downgrading
nqgenoldverrpd [-P repository_password] -I input_repository_pathname –O
output_repository_pathname -V version
-P: your RPD password
-I: Repository path and name
-O: Repository path and new name of the rep you want to name for the downgraded version
-V: To which version you want to downgrade.
You can only generate repository of version 302 to 318 [ 318 being 11.1.1.6 Version].

Downgrading Process:
1. Copy the 11.1.1.6 RPD to a location you want to ( Here I copied the file to C drive)

2. Now go to Run > Cmd and type the downgrade command as follows and hit enter

3. After hitting Enter on successful downgrade completion you will get the below screen.

Hope It Helps!!

Thanks,
Shanmugha Bharathy G B

Custom Login pages,Images and Logos in OBIEE11G

Custom Login pages,Images and Logos in OBIEE11G

1. Create a custom image in the standard size and keep in the following paths and restart the services .

Drive:\Middleware\Oracle_BI1\bifoundation\web\app\res\sk_blafp\login
Drive:\Middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\.appmergegen_1316154755380\analytics.ear\ukjjdc\res\sk_blafp\b_mozilla_4
Drive:\Middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\.appmergegen_1316154755380\analytics.ear\ukjjdc\res\sk_blafp\login
Drive:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\sk_blafp\b_mozilla_4
Drive:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\sk_blafp\login

.appmergegen_1316154755380 this folder number may vary from from one server to another and if this folder is not present also dont worry let the image be replaced at rest of the folders and restart the services.

PATCH UPDATE (USERNAME/PASSWORD) ISSUE FACED FROM 11.1.1.6.0 TO 11.1.1.6.12

PATCH UPDATE (USERNAME/PASSWORD) ISSUE FACED FROM 11.1.1.6.0 TO 11.1.1.6.12

Hi,

Recently we updated our OBIEE version from 11.1.1.6.0 to 11.1.1.6.12.
In 11.1.1.6.0 chrome was not working properly. Issues faced like catalog not opening and only loading symbol appears for long time.

So we planned for patch update.
After patch update we dont find any issues which we faced earlier.
But during patch update automatically username and password has been changed by default.
For this we have to update username and password manually in two areas.
You will be getting Error cause : Error retrieving user/group data from Oracle BI Server's User Population API.
Solution :
Make sure have same password at the below
in Oracle Weblogic Server : Console / Home >Summary of Security Realms > myrealm > Users and Groups > BISystemUser
AND
in EM, weblogic domain > bifoundation_domain > Security > Credentials > oracle.bi.system -> system.user

Thanks,

Shanmugha Bharathy G B

Hope it Helps!

Custom Sign Out Text in OBIEE 11g

For Sign out text the changes to be done in productmessages.xml file.

D:\MiddlewareHome\Oracle_BI1\bifoundation\web\msgdb\l_en\messages

Search and replace FROM name="kmsgProductGeneral"><TEXT>ORACLE BUSINESS INTELLIGENCE</TEXT><HTML>ORACLE BUSINESS INTELLIGENCE</HTML>

To your custom text as below name="kmsgProductGeneral"><TEXT>SBL BUSINESS INTELLIGENCE</TEXT><HTML>SBL BUSINESS INTELLIGENCE</HTML>

Text has been replaced in both the tags to display at sign page

Thanks,

Shanmugha Bharathy G B

Hope It Helps!!

Custom logo for Login and Home Page of OBIEE 11g

1. The changes of the image are done in the below two folder paths.

Copy your image and paste in below mentioned two folders.

D:\MiddlewareHome\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\sk_blafp\b_mozilla_4\ oracle_logo.png
D:\MiddlewareHome\Oracle_BI1\bifoundation\web\app\res\sk_blafp\b_mozilla_4\ oracle_logo.png

2. After the replacement of the images cache from Administrative tool should be removed.

Manage>cache>Edit>select all>purge

3. Then go to Presentation services and clear the cache and reload server metadata.

Administration>Manage Sessions>Cancel Running Request and Close all Cursors>back>Reload files and Metadata.

4. Clear all browser history and cache.

5. Size of logo has to be w:119*h:25 and if the size changes image size conflicts. All the below search bar, Advanced, Administration button etc.. all are integrated into a single template, size and format are called in different css class file which changing may conflict with many files resulting blank display sometimes.

Thanks,

Shanmugha Bharathy G B

Hope It Helps!!

Display TopN Revenue Every Year by Customer in Obiee11g

Display TopN Revenue Every Year by Customer in Obiee11g:

Hi All,

I had a requirement to generate topN Constituents Revenue based on every year. In this blog i am going to explain how to display top 10 constituents revenue for 2012;2013 etc...

1. Create a new analysis with your required columns
Here i have used the following columns and the last column displays our business scenario.

2. For Revenue By TopN column goto>edit formula> and select f(..) formula button, expand aggregate icon and select TOPN function which will look like below screenshot.

3. Then select variable button >presentation variable and type COUNT as Variable Expression and Default Value as 10 like below screenshot.

4. After entering all the values the edit formula value passing pane should look like below screenshot and select ascending to this column.

5. Now we go to to create two prompts for our analysis.

6. Select the “Prompts” tab and click on the ” + ” symbol to create a new prompt, select the “Column Prompt” -> “Time”.”Year”.

7. Keep the default values and make sure these are checked: “Enable user to select multiple values”, “Enable user to type values”, “Require user input”.

8. For the “Default selection” select “Specific Values” and use the ” + ” icon to open the “Select Values” window.

9. In the “Select Value” window select 2013 and 2012 and move them to the “Selected” side and click the OK button.

Refer and make sure the values are correct as per below screenshot:

10. Create One More Prompt:

Add one more prompt by select the ” + ” icon on the “Definition” window.
Select the “Variable Prompt”.
On the “New Prompt” window for “Prompt for” select “Presentation Variable” and on the side box enter “Count”.
For the “Label” enter “Number of Ranks”.
For the “User Input” select “Text Field”.
For the “Variable Data Type” select “Number”
Check the “Require user input” checkbox.
For the “Default selection” select “Specific Value” and enter “10″.
Then finally click the OK button.

make sure it is as below screenshot:

11. Once all done Save the analysis as TOPN Constituents Revenue By Year.

12. The Result look like

13. Select ok and run the analysis.

Hope it Helps!!

Thanks,

Shanmugha Bharathy G B

Global Unique Identifiers (GUIDs) in OBIEE 11g

Global Unique Identifiers (GUIDs) in OBIEE:

What is GUIDs?

In Oracle BI 11g, users are recognized by their Global Unique Identifiers (GUIDs), not by their names
GUIDs are identifiers that are completely unique for a given user
Using GUIDs to identify users provides a higher level of security because it ensures that data and metadata is uniquely secured for a specific user, independent of the user name

Example Scenario:

Refreshing GUIDs

The GUID feature is there to help secure your OBI environments – especially production.
There may however be times when GUIDs become out of sync in and you cannot log in as certain users:

Migrating from WebLogic Embedded LDAP to an alternative identity provider
Deleting users and then recreating them.
Migrating “Production” Presentation Catalog / RPD to the “Development” environment

In order to work around this, you can either:

Delete the offending users from the Presentation Catalog and log in again or
Refresh GUIDs (explained overleaf)

Regenerating GUIDs :

Open up the NQSConfig.ini file for editing:
[OBI Home]/config/OracleBIServerComponent/coreapplication_obis1/NQSConfig.ini
Set the following parameter within the [SERVER] section:
FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;
Save the file
Open up the instanceconfig.xml file for editing:
[OBI Home]/config/OracleBIPresentationServicesComponent/coreapplication_obips1/instanceconfig.xml
Add an “UpdateAccountGUIDs” entry to the <Catalog> section as follows:

<ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">
<ps:UpgradeAndExit>false</ps:UpgradeAndExit>
<ps:UpdateAccountGUIDs>UpdateAndExit</ps:UpdateAccountGUIDs>
</ps:Catalog>

Save the file
Restart Oracle BI System components:
$ORACLE_BASE/instances/instance1/bin/opmnctl stopall
$ORACLE_BASE/instances/instance1/bin/opmnctl startall

To ensure your system is secure once again you must revert the configuration changes!
NQSConfig.ini : FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO;
Instanceconfig.xml : Remove entry for <ps:UpdateAccountGUIDs>
Restart Processes : opmnctl stopall / startall

Hope It Helps!!

Thanks,

Shanmugha Bharathy G B

Configuring Teradata Data Source for Oracle BI Under UNIX

Configuring Teradata Data Source for Oracle BI Under UNIX

Operating System: UNIX only.
Databases: Teradata only.

This task is required if Teradata is to be configured as the only data source of the operationalapplication server.
Before beginning the following procedure, you must know the following information:
The default installation directory paths for Teradata on UNIX, as shown in the following table of Teradata installation default paths under UNIX.
The IP address of the Teradata server.
To configure Teradata as an application server data source
Log on as a separate telnet session.
Go to the directory OracleBI_HOME/setup.
Using vi or another text editor, open the odbc.ini file and add the following section to odbc.ini:

Data Source Name=<Name of the DSN>
Driver=<Teradata ODBC driver Path>/drivers/tdata.[$libsuffix]
Description=NCR 3600 running Teradata V2R5.2r
DBCName=<Teradata Server IP Address>
LastUser=
Username=
Password=
Database=
DefaultDatabase=<name of target database or user>

NOTE: The string [$libsuffix] represents the library suffix appropriate to the specific UNIX
operating system you are using.

For example, for Solaris or AIX, use libnqsodbc.so; for HP-UX,use libnqsodbc.sl.

Example 1. The following is true:

Teradata server is running on IP 172.20.129.42
Teradata ODBC driver is installed at /usr/odbc
Therefore, for Example 1, add the following section to odbc.ini:

[Terav502]
Driver=/usr/odbc/drivers/tdata.sl
Description=NCR 3600 running Teradata V2R5.2
DBCName=172.20.129.42
LastUser=
Username=
Password=
Database=
DefaultDatabase=<name of target database or user>

Example 2. The following is true:

Teradata server is running on IP 172.20.129.42
Teradata ODBC driver is installed on /usr/lpp/tdodbc

Therefore, for Example 2, add the following section to odbc.ini:

[Terav502]
Driver=usr/lpp/tdodbc/odbc/drivers/tdata.so
Description=NCR 3600 running Teradata V2R5.2
DBCName=172.20.129.42
LastUser=
Username=
Password=
Database=
DefaultDatabase=<name of target database or user>

NOTE: The DefaultDatabase parameter may be left empty only if you have checked the entry
Require fully qualified table names in the Repository Connection Pool for this Data Source.

In the same file, in the section [ODBC Data Sources], add the following entry:Terav502=tdata.[$libsuffix]

Example: The new Teradata DSN is Terav502. Therefore, add the DSN entry to
odbc.ini:

[ODBC Data Sources]
AnalyticsWeb=Oracle Business Intelligence Presentation Services
SnowFlake=Oracle Business Intelligence Server
AutoSnowFlake=Oracle Business Intelligence Server
DimSnowFlake=Oracle Business Intelligence Server
DimSnowFlake=Oracle Business Intelligence Server
Star=Oracle Business Intelligence Server
Terav502=tdata.[$libsuffix]

NOTE: The string [$libsuffix] represents the library suffix appropriate to the specific UNIX
operating system you are using. For example, for Solaris or AIX, use libnqsodbc.so; for HP-UX,
use libnqsodbc.sl.

Open up the user.sh script in the same directory and add the library path line to configure the Oracle BI data source, based on the operating system and shell.
Using the Oracle Business Intelligence Administration Tool, open the Repository and add the new DSN you created as the Connection Pool Data Source Name for the appropriate physicaldatabases.
In the example, add Terav502.
Start the Oracle BI Server or, if it is running, stop and restart it.

Hope it Helps!!

Thanks,
Shanmugha Bharathy G B

Configuring Oracle Databases for the Oracle BI Server Under Windows

Configuring Oracle Databases for the Oracle BI Server Under Windows

Operating System: Windows only.
Databases: Oracle only.

If your native database is Oracle, the following conditions must be true:
The machine running Oracle BI Server must use the Oracle Call Interface (OCI) to connect to the database.
In the tnsnames.ora file, the Oracle database alias (the defined entry name) must match the Data Source Name used in the repository connection pools of all physical Oracle databases.
In the repository file, the Oracle database alias used in the connection pools must also be the same as the Data Source Name.
For example, in the following example of a tnsnames.ora entry, the corresponding Oracle
Business Intelligence repository connection pool Data Source Name is ITQA2.

ITQA2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ITQALAB2)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = ITQALAB2.corp)
)
)

The following procedure shows how to check repository connection pool settings against the Oracle tnsnames.ora settings.

To check that an Oracle database refers to the Oracle BI Server machine

Log on to the Server Administration Tool.
In the repository's Physical layer, double-click on the appropriate database cylinder icon. On the general tab, in the Data source definition Database field, select the appropriate Oracle database version from the drop down list. for your data source.
If the Connection Pool is not visible in the Physical layer, click on the (+) navigation control to
the left of the appropriate database cylinder icon to expand it.
Double-click the appropriate Connection Pool to open the Connection pool window.
In the Connection Pool window, check that the following is true:
The Call Interface field displays the appropriate value for the release of Oracle database being used.
The Data Source Name displays the Oracle database alias that you have defined in the
tnsnames.ora entry.
NOTE: This Data Source Name is not the DSN name defined in Settings > Control Panel > Data Sources (ODBC)..
In the Oracle folder, open the tnsnames.ora file.
Check that a valid entry name exists with the following characteristics:
Matches the Oracle BI repository's connection pool settings for the Data Source Name
Specifies the targeted Oracle physical database

Hope It Helps !!

Thanks,
Shanmugha Bharathy G B

Single Button for multiple Global Prompts in OBIEE 11g

Single Button for multiple Global Prompts in OBIEE 11g:
Hi,

This requirement was faced by us and successfully implemented by my Lead. I am sharing since it would be useful for all..

I have shared a simple example of submitting two prompts which may not make much sense because these two prompts can easily be combined into a single prompt and using standard Apply and Reset buttons provides same functionality. However, the real use case is on dashboard pages with say 10~15 complex prompts that need to be logically laid out and can’t be combined into single prompt. Also, complex prompts may have already been built and need to be reused.
In the below screenshot you can see with example how

Each prompt has an Apply and Reset button (more about disabling these buttons later) and the analysis runs separately for each prompt.As I said earlier, it is possible to combine these two simple prompts into one and in this case functionality will be same as the customization but we know it is not always possible to combine large number of prompts. Here is how this example would look if we combine both prompts:

Now add two text boxes as below:

Text 1 has code to hide all Apply buttons. You may be aware of other ways of hiding Apply buttons (check boxes on prompt and dropdown menu on page) but they make prompts execute immediately and we don’t want that behavior in this case. Also, this effects prompts that are placed below on page and this is the reason it needs to be on top.

Text 2 has custom code for two buttons: one Resets ALL prompts and other is to APPLY ALL prompts. Don’t worry about reading all the code, I have the text below. Just make sure your text matches this. For example, ‘Contains HTML Markup’ should be checked and ‘Preview’ button is pressed, you should see two buttons.
Please note that copy/paste can sometimes break keywords and code may not work right away. Correct any errors and use preview button to make sure there are no errors.

<DIV CLASS = “XUIPromptEntry minibuttonOn”><A HREF = “#” ONCLICK = “return PersonalizationEditor.removeDefaultSelection(false)”>Clear ALL Prompts</A></DIV>

<div align = “left”> <a onclick=”javascript:customCall();” href=”#”> Apply ALL Prompts</a><div/>

try{ var aElm=PromptManager.getPromptManager().getAllPromptCollectionJSON();

for(var i = 0; i < aElm.length; i ++ )

{

for(var j = 0; j < aElm[i].promptSteps[0].prompts.length; j ++ )

{

var promptid = aElm[i].promptSteps[0].prompts[j].promptStreamID ;

var g = null;

var h = PromptManager.getPromptManager().getPromptCollectionInfoWithViewID(aElm[i].viewStatePath);

if(h)

{

try

{

var b = h.getAllPromptExprsArray();

if( ! h.verifyPromptValuesAndDisplayError(b))

{

return

}

g = PromptManager.buildPromptExprGivenExpr(“”, b)

}

catch(f)

{

alert(f);

return

}

PromptManager.submitPrompt(aElm[i].viewStatePath, true, “PromptFinish”, g)

}

catch(e) {alert(“Apply ALL Button Exception ” + e.description);

}

</script>

Reset buttons can be disabled using standard navigation:

When this dashboard is run, this how it will look:

Selecting values in each prompt should not change analysis unit Apply ALL Prompts button is pressed:

Once the button is pressed after selecting all prompts, you should see analysis filtered on all prompts:

If you wish to implement this on a page with numerous prompts, please try on a simple page with two prompts first.

Hope It Helps!!

Thanks,

Shanmugha Bharathy G B

Single Prompt Switching Multiple Reports in OBIEE 11G using Presentation Variables

Single Prompt Switching Multiple Reports in OBIEE 11G using Presentation Variables:

What is Dashboard Prompt?

A prompt that is created at the dashboard level is called a dashboard prompt because the prompt is created outside of a specific dashboard and is stored in the catalog as an object, which can then be added to any dashboard or dashboard page that contains the columns that are specified in the prompt.
A dashboard prompt can be a column prompt, variable prompt, image prompt, or currency prompt.
Dashboard prompts are reusable, because you can create one prompt and use it many times.
When the prompt object is updated and saved, those updates are immediately displayed in all dashboards where the prompt is used.
A dashboard prompt is a specific kind of filter that, when created, saved, and applied to a dashboard or dashboard pages, can filter all or some of the analyses that are embedded in a dashboard or analyses that are embedded on the same dashboard page.
A dashboard prompt is interactive and will always be displayed on the dashboard page so that the user can prompt for different values without having to re-run the dashboard.
Users can create and save dashboard prompts to either a private folder or to a shared folder.

In this blog i am going to share how a single prompt functions with Multiple reports using Variables.

I have used 4 reports which I want to switch using dashboard prompt which are MASSACHUSETTS , NEW YORK, CALIFORNIA and TEXAS . Here is an example along with the steps:

1. Create a Dashboard Prompt with the intended reports as a data value (MASSACHUSETTS , NEW YORK, CALIFORNIA and TEXAS) to be selected.

2. Click on New->Dashboard Prompt->select any subject area. Note: It will not affect on our dashboard prompt as we have to create presentation variable of our choice.

3. Definition Pane for dashboard prompt will open. Now select "Variable Prompt" as below.

4. Now "New Prompt" dialogue will open. Create presentation variable as VARIABLE 1,label it as SELECT REPORT and select User Input as Choice List.

5. In Choice list Values click on plus (Green Icon) sign; it will display "Enter New Value" dialogue. Now manually enter the names of the reports which you want to display in prompt. Here I will put my four report names which I want to display as a list in dashboard prompt which are MASSACHUSETTS , NEW YORK, CALIFORNIA and TEXAS as below :

6. Now expand the Options. In "Default Selection" you can give any report name which you want to display by default on dashboard by selecting that report name as "Specific Custom Value". Here I have given "MASSACHUSETTS" as my default selection.

7. Now save your dashboard prompt. In this way our dashboard prompt is ready from selecting reports which will look like :

8. Create reports which you want to display according to selected report name in dashboard prompt.

9. Now I will create four reports named MASSACHUSETTS , NEW YORK, CALIFORNIA and TEXAS and will apply some filters in theses individual reports which will allow me to show the intended report as per selection made in dashboard prompt. So let's create "MASSACHUSETTS"

10. I am taking some columns in reports plus one dummy column. I have change the column formula of Dummy column as:

CASE '@{VARIABLE 1}' WHEN 'MASSACHUSETTS' THEN '1' ELSE '0' END

11. Now I have applied filter on Dummy Column as "is not equal to /is not in" '0'.

12. Repeat the same process for rest of the three reports New York, California and Texas

CASE '@{VARIABLE 1}' WHEN 'NEW YORK' THEN '1' ELSE '0' END

CASE '@{VARIABLE 1}' WHEN 'CALIFORNIA' THEN '1' ELSE '0' END

CASE '@{VARIABLE 1}' WHEN 'TEXAS' THEN '1' ELSE '0' END

and

apply filter on Dummy Column as "is not equal to /is not in" '0'.

13.Putting dashboard prompt and three reports in Dashboard by applying certain conditions on each sections in "Edit Dashboard".

Note: Put all the reports and dashboard prompt in separate sections as we have to apply the condition on section.
14. Now I am applying condition in section of "MASSACHUSETTS" by clicking on Properties > Condition > Section Condition as below :

15. Similarly follow the same for rest of the three reports.

16. Now save your dashboard page and run it.

17. Here "MASSACHUSETTS"is my default report so it is visible on my dashboard by default. Now whatever options (report name) you will select from prompt those report will be shown. It is not necessary to show one default report; you can remove default selection from dashboard prompt.

Output:

18. If you select the prompt value MASSACHUSETTS corresponding report will be viewed and the same applicable for NEW YORK, CALIFORNIA and TEXAS.

Hope It Helps!!

Thanks,

Shanmugha Bharathy G B