Hi All,
This blog gives an overview and some design tips for designing Dashboards using the BEx query for Beginners.
As we all know that the today's requirement for using BEx in Dashboards is steeply increasing and also SAP have made better integration of BEx with Business Objects Dashboards.
It is suggested that we follow a Process in designing Dashboards which will give us the better control and also reduces the unnecessary rework.
But being a beginner, the probability of interacting with the Customer/Client is low.
First, we need to understand the Connection between Business Warehouse(BW) and Business Objects DashBoards.
BW - Business Warehouse
CMS - Central Management Server
DB - DashBoard
OLAP - Online Analytical Processing
U1,U2,U3,U4 - Users
RC - Relative Connection
CMS is Central Management Server and the heart of SAP Business Objects Enterprise System which includes User Authentication, CMS
Database, access rights etc.
We can create a dashboard in the local Workstation but if we want to publish it in the server then we need to have a user(Named or Concurrent) in the CMS .
A user is created in the CMS by the Administrator. Users are given different access levels. For Example, a beginner is given access to only few folders in the CMS whereas Admin will have full access.
A Session will connect a User to the CMS server by just logging in using the credentials. We can create a Session in IDT( Information Design Tool) or UDT
(Universe Design Tool). Once the session is created and opened, it will display all your Connections, Universes and files that are under your access levels in the IDT.
Now, we need to create a connection between BW server and CMS server to access the Query. So, we will create the connection in IDT as OLAP connection
through BICS client. BICS interface is the only connectivity to SAP BW from SAP Business Objects.
To connect to other data sources, we shall use the Relational Connection.
Finally, Publish the connection in the Repository so that when you add the query in the DashBoard, you will see this connection and so you can use it.
Finally, User is created by the Admin and session is opened in the IDT. An OLAP connection is also established between BW server and CMS through BICS which will interact with the BEx query.
The below screen shot gives us the simple Process in designing the Dashboards. It starts with 'FREEZE THE DESIGN' . In future, the customer may come with some new requirements so cycle starts again.
Before we open the Dashboards in our Workstation, it is better that we start designing on a sheet of paper. This makes us to analyze many parameters like
Once we have made an analysis of the design, then we shall go ahead in designing on screen. Because, designing on a sheet of paper gives us clear idea of
everything we need on DashBoard. This method of Designing on sheet of paper will make us confident because we are mentally prepared about the design.
Now, it's time to show our creativity on the screen.
User Experience is very Important in dashboards as the Customer expects a pleasant feeling in using it.
Everyone of us are creative and to make the end user addictive to our dashboard, then we shall understand some science behind the User Experience.
Check out the below link about the "Cognition & Intrinsic User Experience"
http://uxmag.com/articles/cognition-the-intrinsic-user-experience
We know to add and edit the query but understanding the importance of Filter option is essential.
Most of the errors come from incorrect linking of the components so I suggest you to remember the below three points.
Take a component and
After all the components are properly mapped, then preview the data.
You can select any of the two options depending upon your needs as it gives us perfect sizing and the perfect look on the screen.
The dashboard can be previewed in different formats.
Then save it to the Repository and also locally in the available formats.
File ------> Save Platform as -------> Dashboard Object as desktop only
File ------> Save Platform as -------> Dashboard Object as desktop and Mobile
Finally, launch the 'Launch Pad' and view the Dashboard that you have created.
I felt sharing to all of you which I learnt along the way and also believe that this blog gives you some overview/idea and tips about the Dashboard.
Thank you a lot for reading this blog !!!!! :smile:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
36 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 |