Welcome to the Oracle Analytics Community

Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Gianni Ceresa Mod

Comments

  • Your "Groupo de columnas" is created because you have a column selector view in your analysis. When you add a column selector to an analysis and enable it on a column, that given column is replaced in the "Criteria" tab by an column named 'Column Group (Default: <default column>)'. The click behaviour is just as Christian…
  • What do you mean? The "table prompt" is the prompt part of the table view in an analysis? That one isn't a real prompt, it doesn't filter the query or anything. It's a visual element only.
  • Is this a question from a pure theoretical point of view? If a soft-limit exists, you would have to ask internally. Technically nothing would prevent a very large number of physical tables, even if most of the time the ID attribute (which isn't supposed to be used anymore as the UID is the official unique identifier but…
  • You need a custom piece of code. In MOS, in some blog posts and in the doc (I believe) there are pieces of examples. OBIEE agents can't write to the filesystem, that's why you need a server script to do that (an EJB if I'm not wrong).
  • You will need to be provide more info to get a valid reply ... What product? What version? What environment? What "fatal error" (you only posted INFO)? How are you trying to "start OBIEE Admin server"?
  • Aren't they on top by default? Because that's where I see them .... As you don't give any info about the product and version it's difficult to give a less vague reply ....
  • Tools > Options By default since many years it's off as the "good practice" is to rename things in the business model (because 1 business model = 1 or many subject areas, so renaming in BMM is 1 place vs potentially many places).
  • Keep in mind you generally always have a "Help" button on most screens of the RPD. In this case you would see: Select Writeable to enable write back for this column. See "Enabling Write Back On Columns" for more information. There isn't a default time dimension, you have to set it yourself. As I always set a time dimension…
  • Examples for the joins? In the physical layer you only provide formulas about how one table relate to another one. The simple one is Table1.ColumnA = Table2.ColumnB, but you can also have more complex formulas like Table1.ColumnA = Table2.ColumnB AND Table1.Date BETWEEN Table2.DateFrom AND Table2.DateTo . It's really only…
  • That's a key element of OBIEE and also a main difference with many other tools. The physical layer defines the objects (tables and columns) and where they are (database, XML file etc.) and the technical condition connecting them (the join formulas like colA = colB or more complex rules). The BMM layer defines the role and…
  • Hi, OAS vs OAC: https://docs.oracle.com/en/middleware/bi/analytics-server/whats-different-oas/index.html#OASWD-GUID-5B9072FD-C869-4EC4-A… OAS vs OBIEE 12.2.1.4: https://docs.oracle.com/en/middleware/bi/analytics-server/whats-different-oas/index.html#OASWD-GUID-C907A4B0-FAFD-4F54-9… Some 3rd party resources:…
  • That's something your OS has to deal with. For example https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/6/html/installation_guide/s1-boot-init-shutdown-r… or a custom script executing the command you would run by hand (making sure it will be executed as the correct user) in init.d. You can also write…
  • Hi, Sorry to ask but, why do you want to mitigate something which maybe doesn't concern you? Is your OBIEE publicly accessible? 3808468 wrote:Protecting Pages in Oracle BI EE from Attack This doesn't literally mean anything. In OBIEE I'm more scared by users being allowed to build analysis with 154 columns and dumping out…
  • You want to display when the data was last loaded in your database? Or when the data was last retrieved by OBIEE from your database (which would imply you have caching in place without a proper cache management strategy) ?
  • Hi, Nope, prompts (in all the views: table, pivot, chart etc.) are single values only. To have a multi choice list you have to switch to a "full" prompt (dashboard prompt for example) and filter your analysis by it.
  • Hi, "deeplink" don't exist in OBIEE and therefore no answer for 1-, 2- and 3-. Maybe it's worth asking that in a OTBI forum?
  • Good question ... I find the info about instanceconfig.xml in the XSD file defining all the allowed tags in instanceconfig.xml (I was looking at a 12.2.1.1 version, I don't think it changed in .4), you can see a screenshot of the part about the secure flag below. So instanceconfig.xml will accept that setting. The unknown…
  • Hi, Did somebody run a security scan/audit on your OBIEE and they gave you a long list of things being "unsecure" ? 3808468 wrote:the web application sends non-secure cookies over ssl in obiee ? What is a "secure" cookie for you? If you mean the "secure" flag of the cookies being set, you must also know that this doesn't…
  • If you are after what Christian guessed (restrict access to that URL), the question is: why? That URL doesn't give you anything, it's internal cooking of OBIEE, nothing you have to care about. Next you will ask how to prevent access to every single icon picture and any other "static" file like CSS and JS? Don't confuse…
  • As Christian said that's called Master-Detail in OBIEE. I would just question the choice: a pie chart? You don't want that, trust me! Your pie chart looks great when a user open only 3-5 different analysis/pages, it will be totally useless with more than that and just a nightmare for a user who opened 20-30 objects. If…