Art of Business Intelligence | Business Intelligence Guidance, Thought Leadership, and Experience. Q&A: How to find current Inventory Quantity? | Business Intelligence | Dashboards. Q&A: How to find current Inventory Quantity? Admin Question: How to find the current quantity in Oracle Inventory. What is the table and column details? The short answer is, you can get the current inventory balance by querying the mtl_onhand_quantities view. To get the current balance you would have to write a query like select sum(transaction_quantity) from mtl_onhand_quantities where inventory_item_id=1234 and organization_id=201 Why do we need to do a sum? MTL_ONHAND_QUANTITIES is maintained as a stack of receipt records, which are consumed by issue transactions in FIFO order. MTL_ONHAND_QUANTITIES has two columns, CREATE_TRANSACTION_ID and UPDATE_TRANSACTION_IDs to join to MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID the transactions that created the row and the transaction that last updated a row.
Items going out => -ve Items coming in => +ve So to get the exact count you would have to sum all the transactions. ShareThis. MOS HTML Update 19122010 « Oracle BI By Bakboord. IFrame bursting - OBIEE 11G | obieefans.com. If you want to display OBIEE 11G content in any other portals using IFrames, You will end up with a message “OBIEE content cannot be displayed in an IFrame”.
Because In OBIEE 11G, Oracle added framebusting check, to avoid the clickhacking security atatck. To control the IFrame rendering we need to add the following tags in instanceconfig.xml within security key and restart the OBI Presentation Service. <InIFrameRenderingMode>allow</InIFrameRenderingMode> OBIEE 11G support 3 modes of IFrame bursting checks 1. prohibit: Never allow OBIEE 11G content to be rendered in IFrame. 2. sameDomainOnly: Allow rendering in IFrame if enclosing page was generated by the server in same domain. 3. allow: Always allows in-IFrame rendering.
So based on your requirement you need to change/add the IFrame bursting configurations to your OBI Presentation Server. OBIEE 11g: "OBIEE content cannot be displayed in an IFrame" OK, so I started this blog because of the issue of not being able to render an OBIEE page within a Hyperion Web Analysis HTML window. I needed to do this for some additional functionality required prior to converting the entire Web Analysis dashboard over to OBIEE (still looking at Essbase connectivity with OBIEE to see if it is a viable solution). I found half the solution on someone's blog, but half the solution doesn't help. Below are both sides of the solution. 1) Locate the instanceconfig.xml file at the location:[OBIEE_HOME]\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\Update the instanceconfig.xml file to add the highlighted entry within the "security" tag (possible values are 'allow', 'prohibit' and 'sameDomainOnly'): <Security><InIFrameRenderingMode>allow</InIFrameRenderingMode><!
Now, this will only get you half way. 2) Edit the 'web.xml' file at the following location: [OBIEE_HOME]\oracleBI1\bifoundation\web\app\WEB-INF\ 11 OBIEE 11g Tips: #7 Action Links. We set the product name column as the value to be passed for the parameter at runtime.We can click the Hidden flag to prevent an additional popup dialog which allows the end user to modify the parameter value.
Note: For some reason (maybe related to the product name hierarchy, the above scenario only works when we use a function like Left("Products". "Product",100). Only then will the product name show up as the parameter value. Otherwise, numbers appear...Test Now open the preview window and click a product name. The link text appears: After clicking on the link text, the twitter page opens, displaying the search results: We can use the same approach for all other web sites which accept parameters.
Have a nice day @lex. Total Business Intelligence - Oracle Business Intelligence Enterprise Edition (OBIEE), Total-BI. Search | Business Intelligence Consulting Group. Working with the Master-Detail Report Feature of OBI 11g (pt. 1) One of the new features included in OBI 11g is the Master-Detail linking feature. The Master-Detail linking allows you to establish a relationship between 2 or more views; one view is called the Master and will drive changes in 1 or more views called detail views. You can think of a Master-Detail relationship in a similar manner that you would when navigating from 1 report to another works, but you do not lose sight of the master view.
So, how do we implement a Master-Detail link? We start out by defining an analysis that will be used to create the master view. Here we have created a simple analysis and filtered for Year = 2008. Now we want to configure this analysis so that we can create our master view. Here we select the “Send Master-Detail Events” under the Value Primary Interaction. Unlike some interaction options like Action Links” which is available on both Column Heading and Value, the Master-Detail option is only available on the Value.
OBIEE « Oracle BI By Bakboord. OBIEE11G Presentation Variable To Dynamically Switch Filtered Column Values Based On Dashboard Prompt Values. Hello Again Today, I want to blog about a scenario that I have encountered, which is very interesting to me. Let me describe the scenario without getting too much into details. In the dashboard, the user want to be able to have an option to filter either by Month or by Year with a switch. In other words, the first thing they want to do on a dashboard is to select the option of "Year" or "Month". Once the option is selected, the next prompt will change to either filter by "Year" value or by "Month" value.
The report that they are querying against is the same report that show be able to go either 'year' or 'month'. The first thing that needs to be done is create this "switch" on the dashboard. In the prompt creation list, go to 'Option' and set the "choice list value" to 'Show SQL result'. SELECT case when 0= 1 then "Time". " The code will generate 2 values 'Year' and 'Month' as a result of the union of 2 select statement. So let's take a look at this next prompt 'Period': So far so good. Oracle Business Intelligence. OBIEE - Date presentation variable - Which mask format ? | GerardNico.com (BI, OBIEE, OWB, DataWarehouse)
About This article talk about the manipulation of a presentation variable with a date datatype. Starting with OBIEE 10.1.3.4.1 and higher versions, Dashboard Prompt input formats and presentation variable values for DATE & DATETIME columns are standardized to YYYY-MM-DD & YYYY-MM-DD HH24:MI:SS Articles Related The big mistake One big mistake that is made with the date, is that people may confuse between : the format of a date and the data type of a date. Why ? Sh@orcl>select DAY_NAME FROM times WHERE time_id = '01-JAN-95'; DAY_NAME --------- Sunday Oracle take the string '01-JAN-95' transform it as a date and perform the query. But what happen if you change the format of the date with the NLS_DATE_FORMAT parameter because you are in a multi-language environment : You fired an error because Oracle expected an other date format to be able to transform it as a date data type.
To be able to support the localization, you must send to the database not a string but a real value with a date data type. April 2010. OBIEE. How to Change the Date format to custom one in OBIEE | OBIEE.