Posted on May 18th, 2008 by Kamlesh Jethwa
How to know which Discoverer sessions runs specific workbook, what application user ID and responsibility, what they are running?
Step 1:
======
/* Create funciton in Database base using APPS Schema */
Create or replace function disco_client_info
(workbook_name varchar2) return number is
BEGIN
–Set the client inforamtions
DBMS_APPLICATION_INFO.SET_CLIENT_INFO(fnd_global.user_id||’~’||fnd_global.resp_id||’~’||workbook_name);
return 1;
–
END disco_client_info;
/* Grant execute privilege to Public */
Grant execute on disco_client_info to Public;
/* […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
Dashboards continue to get a lot of attention in most organizations, Not just because of their visual appeal but they help organizations communicate strategy, monitor and adjust the execution of strategy, and deliver insights to all.
Let us break this into simple terms.
Dashboards, in the most simplest terms is a collection of different reports, all in […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
Dashboards continue to get a lot of attention in most organizations, Not just because of their visual appeal but they help organizations communicate strategy, monitor and adjust the execution of strategy, and deliver insights to all.
Let us break this into simple terms.
Dashboards, in the most simplest terms is a collection of different reports, all in […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
One of the newest feature in InfoCaptor is the Dashboard Tree as shown below.
This is a powerful dashboard object browser that displays all the portlets in a Tree outline. All the children portlets (drill portlets) are automatically shown as child nodes. This tree browser provides single click refresh to any portlet. You can toggle between […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
One of the newest feature in InfoCaptor is the Dashboard Tree as shown below.
This is a powerful dashboard object browser that displays all the portlets in a Tree outline. All the children portlets (drill portlets) are automatically shown as child nodes. This tree browser provides single click refresh to any portlet. You can toggle between […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
Quickbooks is a very popular “micro ERP” application and dominates the Small Business Market. One of the benefits of using Quickbooks for my own business is the simplicity and ease of use. You can run a report and from the report you can drill down straight to the transactions. I learnt a lot of things […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
Since this website receives lot of requests on ERP training institutes in India and in USA, I would like to create a section dedicated to this need. So if you or people you know have first hand experience with any institute please feel free to put the Name, address, website into the comments section of […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
In his blog, James Taylor, highlights some interesting points in response to this article.
“The idea that dashboards are the endgame for BI is frankly terrifying. Have you see the typical dashboard? To misquote Shakespeare, “Much color and expense, signifying nothing”. Seriously, dashboards may be a step up from greenbar reports but the endgame? I don’t […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
One of the newest feature in InfoCaptor is the Dashboard Tree as shown below.
This is a powerful dashboard object browser that displays all the portlets in a Tree outline. All the children portlets (drill portlets) are automatically shown as child nodes. This tree browser provides single click refresh to any portlet. You can toggle between […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
In DBI (Daily Business Intelligence), the cost center hierarchy is maintained in the following table “fii_cost_ctr_hierarchies”
So, using the above table, it is possible to get all children for any given node. (This is possible from the FND tables in Oracle apps too)
Here is the query
SELECT child_value
FROM
(
SELECT LEVEL,
parent_cc_id,
child_cc_id,
child_value,
lpad(’ ‘, 3 *(LEVEL -1)) || child_desc cc_hrchy,
next_level_is_leaf_flag
FROM
(
select
h.parent_cc_id
,h.child_cc_id
,node_child.flex_value child_value
,node_child.description […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
We just did an official PR on the new version of Discoverer Dashboard. Here is the link
What do users say about this tool?
“Coming into an environment where it’s your responsibility to perform data analysis on thousands of Discoverer reports can be a very daunting task. Trying to identify who owns the reports, how many reports […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
How to know which Discoverer sessions runs specific workbook, what application user ID and responsibility, what they are running?
Step 1:
======
/* Create funciton in Database base using APPS Schema */
Create or replace function disco_client_info
(workbook_name varchar2) return number is
BEGIN
–Set the client inforamtions
DBMS_APPLICATION_INFO.SET_CLIENT_INFO(fnd_global.user_id||’~’||fnd_global.resp_id||’~’||workbook_name);
return 1;
–
END disco_client_info;
/* Grant execute privilege to Public */
Grant execute on disco_client_info to Public;
/* […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
Quickbooks is a very popular “micro ERP” application and dominates the Small Business Market. One of the benefits of using Quickbooks for my own business is the simplicity and ease of use. You can run a report and from the report you can drill down straight to the transactions. I learnt a lot of things […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
Do you currently follow any prototyping strategy?
In order to prototype dashboards, you need some sample data and the dashboard tool available that you can report against.
Now where do you get the sample data from? Remember, you just need to create a prototype so you can instantly (within couple of hours) go back to the user […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
Do you currently follow any prototyping strategy?
In order to prototype dashboards, you need some sample data and the dashboard tool available that you can report against.
Now where do you get the sample data from? Remember, you just need to create a prototype so you can instantly (within couple of hours) go back to the user […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
From a real user
——-
It isn’t often you find a product that has the two cardinal virtues: a price that’s an order-of-magnitude below the big players in the field, and a development team that really listens and responds to customer feedback and requests. InfoCaptor is such a product.
Dashboard design and use has swept through the Fortune […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
From a real user
——-
It isn’t often you find a product that has the two cardinal virtues: a price that’s an order-of-magnitude below the big players in the field, and a development team that really listens and responds to customer feedback and requests. InfoCaptor is such a product.
Dashboard design and use has swept through the Fortune […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
We just did an official PR on the new version of Discoverer Dashboard. Here is the link
What do users say about this tool?
“Coming into an environment where it’s your responsibility to perform data analysis on thousands of Discoverer reports can be a very daunting task. Trying to identify who owns the reports, how many reports […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
We just did an official PR on the new version of Discoverer Dashboard. Here is the link
What do users say about this tool?
“Coming into an environment where it’s your responsibility to perform data analysis on thousands of Discoverer reports can be a very daunting task. Trying to identify who owns the reports, how many reports […]
No Comments »
Filed under: Business Intelligence, Oracle Apps
Posted on May 18th, 2008 by Kamlesh Jethwa
Dashboards continue to get a lot of attention in most organizations, Not just because of their visual appeal but they help organizations communicate strategy, monitor and adjust the execution of strategy, and deliver insights to all.
Let us break this into simple terms.
Dashboards, in the most simplest terms is a collection of different reports, all in […]
No Comments »
Filed under: Business Intelligence, Oracle Apps