Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
What are the errors that you are getting? Sent from my iPhone
-
Take a look at this for some guidance- http://ssssupport.blogspot.co.uk/2013/08/odi-11g-creating-odi-dashboard-with.html?m=1 Sent from my iPhone
-
You can use your Dashboard Prompt to populate a presentation variable factColumn for example with values A and B as an example. The value of the presentation variable can then be used in a column formula in your report to determine which measure to use based on selected presentation variable value. The column formula would…
-
You'll need to provide a bit more detail if you require any assistance. Can an you provide some screenshots as a starting point?
-
In that case, usage tracking should do that for you. http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1116/ut/ut.html
-
Take a look at this for some guidance - https://www.cdata.com/kb/tech/ganalytics-jdbc-obiee.rst
-
Hi Anilesh There isn’t much to go on with the limited information that you have available. The only way to debug this is to look at the log files. Do you have Enterprise Manager access?
-
Can you provide the column formula of the Product fcolumn both master and detail reports. Could you also send a screenshot of the filter criteria in your detail report?
-
Have you pulled out the query generated by the BI Server and executed that directly in your Oracle DB? First thing would be to rule out any DB issue then next step would be to look at rpd.
-
Have you used this document as reference? As @Gianni Ceresa mentioned, the file has changed after the 1st 12c release. The file to use is datamodel.cmd. The documentation link I provided gives you information about the exact location of this file.
-
Could you retry with the -D parameter.
-
Can you provide some screenshots of these peculiar issues that you are having?
-
As @Gianni Ceresa mentioned, you just need to make use a combination of the LOCATEN & SUBSTRING functions to achieve this.
-
Have you attempted to restart your BI server? are there any errors in the BI server log file worth noting here?
-
When you say you deployed your 11g Rpd and catalog, did you upgrade first or just copy them over from 11g environment to your 12c environment?
-
You can do this either at ETL level (preferred ) or in OBIEE. Firstly, will you only have 4 columns? Is there a chance that there can be more? This will have an impact on the logic.
-
Have you checked the status of your OBIEE components? Is the Node Manager up and running? Admin Server, Managed Server, OPMN components? Run the status.cmd/sh script to check these. It is located in <MW_HOME>/user_projects/domains/bi/bitools/bin
-
The information you'be provided is rather vague. Could you provide more detail and possibly include some screenshots?
-
For your COUNT, you'll need something like this: COUNT(id BY code) For your date, you'll need something similar: MAX(date(TIMESTAMP_CREAZIONE) BY code) For the Description, do you want to return the value that corresponds to the MAX date(TIMESTAMP_CREAZIONE) for that code? It seems to me that the description and date are…
-
That's great. Mark as correct to help others who might have a similar issue in future.