We provide online trainings on data warehousing, data visualization and analytical tools like Cognos BI series, Cognos TM1, Informatica, Qlikview, Tableau. Please feel to contact us - bharati.dwconsultancy@gmail.com or cell # +1-562-646-6746 (Whatsapp enabled).
Report Prompts:
Induces report inter-activity. Asks the users to select a value to filter the data on.
3- Ways of Creating Prompts:
1- Using variable name between two question marks (??)
Create a filter and add a variable name between 2 question marks.
2- Using 'Build Prompt Page' Button.
Select a column to apply filter. Click on 'Build Prompt Page' Button.
3- Creating a manual prompt page
Goto Page explorer.
Click on Prompt Pages. Create a new page.
goto Toolbox...Drag value prompt...... Create the prompt...
and run the report.
Creating Dashboard in Report Studio:
In information technology, a dashboard is a user interface that, somewhat resembling an automobile's dashboard, organizes and presents information in a way that is easy to read.
We will see how to create various Dashboards using a Simple Report Studio Principles.
1- Drag and Drop a Table - 2C x 2R. (C- Column / R-Row)
2- Drag a list in the table Top Left@ 1C-1R
3- Drag a Column-Chart in the table Top Right@ 2C-1R
4- Drag a Bar-Chart in the table Bottom Left@ 1C-2R
5- Drag a Line-Chart in the table Bottom Right@ 2C-2R
6- In the list Drag Year/Country/City/Sales Amount/Sales Quantity
7- Now, this list query can be used to feed in data for the various different charts.
8- Associate List Query-1 to all the charts. Select one chart at a time and in the properties pane, Link Query-1
9- From the data Items Tab, In the measure / axis section drag and drop various query items as shown. Run the dashboard.
10- Now, lets make it more interactive - add two prompts - year/country at the dashboard page itself.
11- Make these prompts optional / enable auto-submit.
12- You may need to refer - P-2 Creating Prompts video for more information on prompts.
13- Run the dashboard.
14- Format the dashboard as per your creativity - add colors etc to make it look good.
Report Formating using Conditional Variable:
Applying a formating, based on a data item value is conditional formating.
For this, we need to define a condition-variables
There are three types of variables:
Report Language: For achieving Multi-lingual
Boolean: Values either Yes or No.
String: Values based on Condition
In this excercise, we will see Boolean variable:
1- Create a list report with Country, Year, Sales Amount, Sales Quantity
2- Now, we want to highlight values under 15 for Sales Quantity in RED COLOUR
3- While, values over 15 for Sales Quantity in GREEN Colour.
4- Go to Condition Explorer, create a Boolean Variable.
5- Define a condition: SalesQuantity < 16
6- Click Ok and Close the expression editor.
7- Notice the possible values on the right side of the condition-explorer page YES/NO
8- Go back to Page Explorer.
9- Select the Sales Quantity - column body
10- This is an important step: Being on the Report Page, take your mouse pointer over condition explorer
11- From the available values for the Boolean condition, we just created, select YES
12- Notice the bar colour change to green - this indicates: the report layout while condition is VALID
13- Select the Style variable to Boolean1- then Set back ground colour for Sales Quantity to RED
14- AGAIN: From the available values for the Boolean condition, we just created, select NO
15- Notice the bar colour change to green - this indicates: the report layout while condition is INVALID
16- Select the Style variable to Boolean1- then Set back ground colour for Sales Quantity to GREEN
17- Run the report and Notice the background colour.
SO THATS IT..........
************************************************************************************************
Report Formating using Conditional Variable:
Applying a formating, based on a data item value is conditional formating.
For this, we need to define a condition-variables
There are three types of variables:
Report Language: For achieving Multi-lingual
Boolean: Values either Yes or No.
String: Values based on Condition
In this excercise, we will see String variable:
1- Create a list report with Country, Year, Sales Amount, Sales Quantity
2- Now, we want to highlight values under 10 for Sales Quantity in RED COLOUR
3- While, values between 10-20 for Sales Quantity in Yellow Colour.
While, values over 20 for Sales Quantity in Green Colour.
4- Go to Condition Explorer, create a String Variable.
5- Define a case condition: GT / LT / BT (Greater Than / Less Than / Between)
case
when [Query1].[Sales Quantity] < 10 then('LT')
when [Query1].[Sales Quantity] > 20 then('GT')
else('BT')
end
6- Click Ok and Close the expression editor.
7- We need to create the possible values on the right side of the condition-explorer page
8- Create a set of possible values as defined in case condition. GT / LT / BT -- Without the Quotes
9- Go back to Page Explorer / Select the Sales Quantity - column body
10- This is an important step: Being on the Report Page, take your mouse pointer over condition explorer
11- From the available values for the String condition, we just created, select LT
12- Notice the bar colour change to green - this indicates: the report layout while condition is VALID
13- Select the Style variable to String1- then Set back ground colour for Sales Quantity to RED
14- AGAIN: From the available values set BT to yellow and GT to green
15- Run the report and Notice the background colour.
SO THATS IT..........
1- Create a System DSN: Please note that User DSN doesn't work.
2- Goto Start --> Control Panel --> Administrative Tools --> ODBC.
3- Create a System DSN -> Select the Microsoft Driver for MDB.
4- Select the abcd.mdb file.
5- Save the connection.
6- Logon to Cognos 10 Portal.
7- Goto IBM Cognos Administration.
8- Goto Configuration.
9- Data Source Connections--> Click on new Datasource
10- Specify a Datasource name.
11- Select datasource type as ODBC
12- Specify the Name of the System DSN.
You can specify the username and password for the database.
Leave it blank for this database as its not secured.
13- Test the connection. SUCCESS
14- Click Finish.
Cognos 10 Training in Mumbai
Informatica Training in Mumbai
ÒTrainings
ÉCorporate Trainings
ÉClassroom Trainings
ÉOnline Trainings
ÒBusiness Intelligence Consultancy ÒPerform BI & Data warehouse Health Checkups
ÒAssist in BI Project Kick-offs / Execution / Delivery ÒHelp setup BI - Centre of Excellence (CoE)
ÒAssist in BI Project Kick-offs / Execution / Delivery ÒHelp setup BI - Centre of Excellence (CoE) ÒSetting up Standards and Guidelines for a BI-DWH Project. ÒAssist in evaluation of various BI/DWH tools for your Business; inline with clients Budget and requirements.ÒFull-fledged BI / DWH implementation.
