Focused Insights: Display tables content in a dashboard
Operation Control Center Dashboard of SAP Focused Insights provides a direct access to key metrics stored inside SAP Solution Manager. It’s primarily intended for IT and business experts who need to quickly build detailed views for in depth analysis.
OCC Dashboard is flexible and easy to use, it offers a single web interface to administrate, configure and display your dashboard instances. Dashboard instances and gadgets can be published as a web URL.
Several data providers help to access data sources on different time periods and different resolutions. You can filter and merge various metrics on the same chart while the look and feel can easily be changed with few clicks.
Since wave 3.2 of Focused insights, you can display the content of database tables in an OCC gadget.
The first step is to access DBACOCKPIT from Solution Manager. From there, select the proper database connection. It could be Solution Manager’s database or one of the databases connected to Solution Manager. In any cases, ADBC connection to the database must be setup properly.
In this example we access the Solution Manager’s database which is HANA. HANA SQL Editor is located in folder “Diagnostics” of DBACOCKPIT. From there, you can edit and test your SQL queries, save and load them from Solution Manager.
Remark: for an Oracle database, the “SQL Command Editor” is located under folder “Performance / Additional Functions”.
In this example we display the next 50 items to come in the IT Calendar (cross context). We build the SQL query below to access IT Calendar items from Solution Manager table CAL_EVENTS.
You can test the SQL Query with button “Execute”, the result is displayed in tab “Result”. Make sure you have future events or work modes planned in your IT Calendar.
Once the SQL query is ready, save it with a meaningful name.
Now access Focused Insights OCC dashboard to retrieve the SQL script output.
From the bottom right of the Focused Insights Launchpad, make sure you have at least the Support Pack 1, with Wave 3.2.
Make sure all OCC data providers are installed (execute program /STDF/INSERT_DATA_PROVIDERS).
Edit an OCC gadget and select renderer DYNAMIC_TABLE.
Add a query to the gadget and select data provider /STDF/DP_SQLSCRIPTS.
Select the SQL script saved previously in DBACOCKPIT (it should appear in the list).
If relevant, select the DB connection. In our case, since we access Solution Manager’s database, we don’t need to select a connection (leave it blank).
Save your gadget and display it.
- If the table is located on the Solution Manager you should not select a connection in the data provider.
- You might experience performance issue with big tables; make sure to limit the number of rows returned by the SQL query. For example, you can use the keyword “LIMIT” with HANA database.
Focused Insights (http://support.sap.com/focused-insights)
Focused solutions for SAP Solution Manager, is the extension concept for SAP Solution Manager, with the idea of helping our customers meet their particular innovation needs on an individual basis, without the need for homegrown software or partner solutions.
The goal of Focused Insights is to build and distribute powerful customer-specific dashboards in minutes using state-of-the-art user experience.
The content delivered with Focused Insights has been designed to deliver, in real time, the most relevant and valuable information to the right people. While it provides full transparency of information stored inside SAP Solution Manager, it also takes into account the best practices and experience gained during numerous custom projects, offering a set of prepackaged dashboards tailored to your needs.
SAP Focused Insights offers specialized dashboards for experts as well as management or non-technical users. Whether they address the CIO or an expert, dashboards remain consistent among each other since they rely on the same data sources mixed up and presented in different granularities or aggregation levels
Focused Insights comes with a rich content. It fully exploits the huge amount of data stored inside SAP Solution Manager. Metrics produced by the activation of a scenario, whether it is IT or business related, become immediately available to the prepackaged dashboards. Raw metrics can be grouped or combined to produce advanced metrics and high level KPIs