Hi @User_SOJXT , In OBIEE/OAS, DATETIME columns in prompts are formatted according to your locale (the custom format that you set up in the SQL is basically ignored if you don't change the data type to VARCHAR). Please follow this procedure to update the default locale for your account: * Login to OBIEE * Click on your…

Hi @User_AD53Q , @Gianni Ceresa already clarified my answer and hope you were able to fix your issue. The fundamental thing is that your column must be displayed with a yellow icon next to it in the Criteria tab of the Analysis. The yellow icon means that the column will be treated as measure, values will be aggregated…

Hi @User_AD53Q , I suspect that your column is treated as an attribute, hence the tool is not calculating any total. You have to force the tool to treat your column as a measure in order to display totals. To do this you can replace your column expression as follows: CASE WHEN 1=0 THEN <Put any measure here> ELSE <Put your…

Hi @User_M2QGE , You can define action links for columns in a union analysis. In the Criteria tab you have to click on Result Columns (and not an a Criteria) in order to get the Column Properties option for your columns and set up any required actions in the Interactions tab. Please note that if you are mixing subject…

Hi @kalikhan , Since the Oracle BI EE data source is available for selection, I expect it to work when defining a bursting query. Can you please share the full log message and your bursting query? I also suggest to create a new analysis by selecting the "Create Analysis from Simple Logical SQL" option and copy/paste the…

Hi @User_VP1WV , There is no way to achieve your goal with a single agent. You have to create one agent for each department or switch to BI Publisher and use bursting as @Brandon_1 already suggested. As an alternative, you can add a hidden page to your dashboard where data for all departments is displayed (e.g. if you have…

Hi @Martijn Ceelen, iConsultancy, OBIEE Consultant , Does the same issue happen with a different browser like Chrome or Firefox? I would suggest using Developer Tools to find out all css files which are impacting charts in Development and Production. Then you should double-check that the files are exactly the same in both…

Hi @user13025527 , Did your charts use to work in the past in Production? How are you promoting your catalog objects from Development to Production? Did you already try to re-create a chart from scratch directly in Production? Does it work?

Hi نصير أحمد ذاهد, Did you install and configure a network loopback adapter before installing OBIEE? This is a mandatory step when you install OBIEE on Windows, otherwise it will stop working when you restart it and the IP address of the server changes.

Hi @Shib Seal-Oracle, Application role definitions and mappings to users/groups are included in the BAR file and can be easily migrated. However, you should create required users and groups (or import them from your corporate authentication provider) in the target environment before importing the roles from the BAR file.…

Hi @Shib Seal-Oracle , You should still go with the BAR file approach as it allows to migrate all BIP objects in the catalog and required application roles as well. Please note that the above is not sufficient to migrate everything. You still have to manually recreate required data sources, delivery channels, and set up…

Hi @R.Hagebeek , Unfortunately, it's not possible to reference variables in the custom message. As a workaround, you can use conditions in a dashboard to control whether to hide your analysis and display an alternative Text object (which supports variables).

Hi @Srikanth Reddy Roddam, Did you open the command prompt as Administrator before running the migration jar?

@User_98QEC Have you tried with the exportarchive.sh command instead of export_service_instance.sh?

Oracle recommend 8 GB or more RAM for OBIEE. With only 6 GB there will be a lot of swapping between hard disk and the RAM, even with only 2 users. With 8 GB RAM I would recommend 512 MB for Node Manager, 2 GB for Managed Server and leave the default for the Admin Server. If you have more RAM you can start with the above…

I say it again: you should increase the Node Manager (and Admin/Managed servers as well) Java heap size as stated in the tuning guide. This should be done for each 12c environment as a post-installation task.

In 12c, Node Manager is monitoring not only managed servers but also BI System components. When starting all the BI processes using start.sh, Node Manager may take longer time to start, so it is recommended to increase the java heap size for Node Manager. Moreover I noticed that it usually improves login times.

Hi, Have you already increased the Node Manager Java heap size? https://blogs.oracle.com/pa/entry/obiee_12c_increasing_the_node Regards

I would use a SQL filter in the analysis like: "Table"."Column" = TRIM(BOTH ' ' FROM '@{Variable}')