Don't double post ... http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bip/tb4word/tbwordbip.htm Notice the grouping in their example table ...

If you have OBIEE the Sample App shows how to do it with Google Charts (here's a blog about it: Google Organization Chart in OBIEE 11G | The Big Data - Business Intelligence by Sandeep Venu ), taking that and coupling it with: https://blogs.oracle.com/xmlpublisher/integration-with-google-chart-and-map You might be able to…

Do this all the time but never used a sequence (seems like overhead for a temp table) ... set a variable just before writing the rows for your data_key as something similar to: select to_number(to_char(sysdate,'DDMMYYYYHH24MISS')) insert_key from dual; insert_key = 16062017134825 ^ then select records based on…

Do it in the query ... any value above your date set to NULL ....

I occasionally get this error when using Chrome and building BIP Interactive Templates. Usually save the template, exit and return and am able to add the column. OR I switch browsers and try it again. I have no explanation why it happens. My thought is occasionally the browser loses sight of what the object name/ID is and…

If I was asked that ... I'd have given my same answer with an explanation of why - coming from years of experience. ^ was confusing this ask with another ... but turns out I'd do it in the data model and not screw around with a template at all ...

Why the insistence on scatter chart? You are trying to convey a conclusion about the data -- that conclusion should be readily visible in the chart/graph/diagram. The Scatter answers a very specific question about what is plotted. Mimicking a scatter (without using the fundamentals of a scatter) is nothing more than…

Why not do it in the Query? Silly example from dual.... select trunc(sysdate) , to_char(sysdate,'DY'), case when to_char(sysdate,'DY') IN ('THU','FRI') THEN trunc(sysdate) +4 when to_char(sysdate,'DY') = 'SAT' THEN trunc(sysdate) +3 else trunc(sysdate) +2 end two_bus_days from dual; ^ MON-WED is 'easy' ... THU gets a MON…

A scatter plot by definition shows the relationship (if any) between two measures ... What you are missing: you have a requirement to show a scatter plot ... how did that happen? Let your users dictate WHAT not HOW. WHAT is it they want to analyze? You, as the BI expert, then choose HOW best to achieve that. Given what I…

I wouldn't advise looking at the Data Models in BIP as similar to OLAP Cubes ... BIP is a pixel perfect reporting engine really useful for mail merges etc ... given your ask about master-detail I'm thinking BIP isn't the right tool for the job. What's the job you are trying to achieve?

Please provide more information ... how are you planning on displaying the information (template)? what does your data model look like currently in BIP?

Why bring the rows over at all? filter them out at the query level.

Then perhaps this isn't the location you are looking for ... let me see if there is another location. I'll fire up my VM (linux) and run some BIPublisher stuff and see where it is writing tmp files to. 

Oracle BI Publisher temp directory set in Publisher's web.xml which is in MWHOME\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\bipublisher_11.1.1\to5gma\war\WEB-INF\web.xml <init-param> <!-- This is the system temp dir for proceessing of temporary files. This can be any directory on your local…

???? Personal (you are learning)? or for your Company (you are working)?

then 2.2.4 unless you are going to host the app ...

Creating PDF Templates - 11g Release 1 (11.1.1)

Also ... post a pic of the Report template list ... do you have one marked default? And is your scheduled job pointing to that specific template as output?

​ thx for helping to tag-team this one!

JMS is Java Messaging ... Provider should be Weblogic and your WebLogic JNDI URL: t3://server:port Mine is t3://myserver.mydomain.com:9704 (my installation is a default setup) use your server name ...