Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Are you looking at the actual log files or are you looking at Enterprise Manager? I’d suggest that you look at the actual log files on your Linux server. https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-464861F6-CD14-443F-9251-E1C5300CEB02.htm#BIESG1674
-
What is the exact issue that you're facing? With this information, we can probably point you in the right direction of which log files to look into. Which version of OBIEE and which OS?
-
Can you elaborate? These commands that you have mentioned are executed from the command line and they should be run by a BI Administrator user. Is your user setup as a BI Administrator?
-
Adding to @Gianni Ceresa response, you will need to create a column with a formula with logic similar to this: FILTER(SUM(measure BY AP dimension column) USING (2nd dimension column <> 'WAC'))
-
You could use Application Roles to manage this. In the rpd, right-click on the subject area in the presentation layer and select the properties menu item. Click on Permissions, and in here you can select the Application Role which should have access. In WebLogic, you'll need to assign users to the Application Roles.
-
You call that command via WLST (WebLogic Scripting Tool) - This document describes how you call it: Oracle Support Document 2202011.1 (How To Configure Data Visualization (/va) and Analytics (/analytics) To Have The Same Logon With OBIEE 12.2.1.2 And Higher) can be found at:…
-
but from your screenshot, your CAST & CASE statement in your column formula returns a CHAR so what type of aggregation are you trying to do on a CHAR column?
-
I've just seen that the OP @1000122 mentioned that the column is a "fake measure". From the column formula in the original screenshot, this column doesn't actually appear to be a measure.
-
In your screenshot above, change the Aggregation Rule (Totals Row) from Server Determined to None.
-
What is the exact format of the Date Column? Does it have a custom date format mask? Is it an actual date column or a string with a date format? Some screenshots may be helpful in getting a better understanding of your issue.
-
Those features disabled are only accessible whilst you connect to your rpd in online mode.
-
What version of OBIEE do you have installed and which OS? With version 12c, you can simply create a script that calls the stop.sh/cmd and start.sh/cmd scripts which are located in the bitools directory.
-
I would have personally used a slightly different approach. I'd use a request variable which is set on the dashboard prompt to determine which of the 3 dashboards has been called. You can then set session variables that hold the values that you need to pass to your analyses for that dashboard based on the request…
-
Is that a Table? If it is, change it to a Pivot Table and that should sort out your issue. If this isn't the issue then we may need to take a further look.
-
There are numerous reported issues with Agents that have an analysis that contains special characters. @Gianni Ceresa is probably referring to this - Oracle Support Document 2353473.1 (OBIEE 12c: Export File Name May Not Be Correct If The Catalog Name Contains Special Characters on Chrome Browser) can be found at:…
-
Can we take a step back? What have you done so far? Which upgrade steps have you followed? we have to set port numbers in 12c as its when you compare with 11g ? OBIEE 11g & OBIEE 12c use different ports by default. Why do they have to be the same?
-
As I mentioned previously, can you additionally ask your DBAs to ensure that there are no other sessions running on the DB when you execute those commands.
-
If I understand you correctly, In a word, yes you need the configuration as all you've done is install the software. This step configures the BI domain. https://docs.oracle.com/middleware/bi12214/lcm/BIEIG/GUID-D5AFD830-8A7D-42CC-8C22-CE68C452CF4A.htm#INSOA369
-
Quickest way would be to speak with your Oracle Account Manager.
-
What version of Windows is this?