Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Sure, add a calculation. It is only inside the workbook and doesn't need a dataflow, and let you do a bunch of things, including pointless things like this example of a sum of 2 numbers coming from some attributes.
-
Classic can be embedded just like content of OBIEE has been embedded in the past 10 years. Security is of course always something you have to deal with and worse case you will see the login screen first. The DV way is totally different and things have been developed around to make it embeddable, while classic is more a DIY…
-
@davidkhala-Oracle when you did check the logs, didn't you find messages like the following? [VALIDATION] [ERROR]:Password contains invalid characters [VALIDATION] [SUGGESTION]:Ensure password contains only alphanumeric, underscore (_), dollar ($) or pound (#) characters configuration Failed. Exiting configuration due to…
-
Can you report it as a bug? Technically the database accept '-' in a password, but it must be quoted. This makes me say that it's a limitation in the application and a design choice to use unquoted passwords, excluding '-' and a number of other special characters. Because of that, I do expect the application to check if…
-
Sadly I don't have one because I don't have a CSI allowing me to open SRs for on-premises products, I only have a few for cloud products (but I can't really report a RCU bug for OAC as it will not be accepted). I did send all the details directly to a PM (@Alan Lee - Oracle-Oracle ) in March 2022 who passed it to the team…
-
Just a last comment: if your database has compressed tablespaces and the RCU try to create the schemas on those, it will fail. There isn't an error saying it's because of compressed tablespaces but it just fail to create some objects in the BIPLATFORM schema and therefore rollback everything else. I did report the bug…
-
The RCU is located in ORACLE_HOME/oracle_common/bin/rcu , you can find details on how it does work by command line in the OBIEE 12.2.1.4 doc (as the RCU didn't change much, it's only the content of the schemas that evolved):…
-
True, in a full install with a separate execution of the RCU. That's the process to follow if you don't have a SYSDBA account. The issue is that the marketplace image does use the implicit call for the RCU creation when calling config.sh, that's also why it doesn't show much details of what the RCU is doing and really…
-
If the compute instance has not been killed, connect via SSH and run the RCU by hand to find out what is the issue with the info you are providing. You say that you confirmed everything is correct but still the tool doesn't like it, therefore something isn't as correct as somebody/something think it is... Are you using an…
-
I didn't try the use case you described, but because your actions aren't referencing any column in an hardcoded way but just sending the context of the click to the target, the action links should work even when there is no value to send (action links generally send columns' values on their left, but no column available…
-
@Indra Sardana-Oracle You probably wrongly clicked on the "best answer", because your reply to Wayne saying you will give it a try isn't the best answer. And you confirmed at the end that Wayne suggestion is what let you solve your requirement. Please mark Wayne's answer as "best answer" to correctly help other users…
-
What Wayne said, use variables and headers can reference them. I wouldn't use session variables because they are defined for every single user, while in your case your dates are the same values for everybody.
-
Starting from the beginning: does your analysis link something? Because the behavior of the tool didn't change in about 15+ years. Linked objects uses full paths from the catalog root and when you move an object, there dependent (linked) objects don't come with it automatically if you don't move them as well.
-
Are the action links "Navigate to BI Content" or "Navigate to a Web Page" ? Because both can be used to open an analysis (or you really mean a report as in BIP report?) (Trying to get a full picture of your current use case)
-
You have an analysis (a report is a BIP report) and when you say the action links do not work, what do you exactly mean? What are the actions expected? Do the actions happen but with wrong values? Do the actions not happen at all? Do the actions reference in any possible way values from the columns behind the columns…
-
What Amrita said. There are 2 kinds of exports: one that goes directly on the criteria and does export your criteria (all the columns you have there) and one that is based on the visual rendering of the view as you see it on your screen (and therefore can have less columns because some are excluded etc.). CSV is an export…
-
It isn't Oracle's role to provide you every kind of GeoJSON file you could need. They provide some as reference, just like some custom plugins are also available, but it isn't meant as Oracle being the official provider for whatever kind of GeoJSON users would need. Go online and find what you need or build it yourself…
-
Use the "Find" filter on top of the list, if you have a fixed naming convention giving all MVs a fixed prefix / suffix, the job is done. A materialized view isn't very different from a table, and that's why it isn't shocking for the wizard to mix the 2 kind of objects. In the end from an OBIEE point of view they do behave…
-
I just managed to do a quick test: a materialized view will be seen by the import wizard as a table. They are there inside the list and don't have a different icon or anything, that's maybe why you didn't see them.
-
MVs works just fine in the RPD, are you saying you can't see them anywhere when using the import wizard? Did you check if they aren't shown with tables or with views or just anywhere else? Of course you can always define them manually, but it does take some more work (you could generate the needed code with SQL, but if…