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

  • First: search the forum, same topic coming every week ... The answer is always the same: where did you see that OBIEE run on Windows 10? Does the compatibility matrix confirm compatibility with Windows 10? No and no. OBIEE is a server product, Windows 10 is a consumer end-user workstation/laptop. So if it doesn't work ...…
  • Add a "filters" view to your analysis. In the same way as you add a chart, a table or a pivot in the "Results" tab you can add the "Filters" view.
  • The hierarchy is mandatory (I assume you have hierarchies for your other dimensions, right? So just add one for this new table as well: grand total and detail level right after, no need to use it or add it to the subject area). A business key can have as many column as you want (the max is all the column of the logical…
  • Yes you must add them into a logical table acting as a dimension. Worst case if you can't find a better business key just add all the columns to it...
  • Hi, I assume you have the attributes coming from the 2 fact tables in the logical fact table? If it's the case you have a problem with your model. In a dimension model the fact table must contains only measures, any attribute must be outside in a dimension. In your case it would be a degenerated dimension (that's how…
  • It would help if you posted at least your OBIEE version, things can be quite different if you are on a old 10g, a bit less old 11g or a current 12c. Look at SampleApp, it has examples for that (the code is provided) and it's the "best way to do it" (as it's Oracle telling you to do it like that ). Live example on Sample…
  • You must buy them! There is no free map officially from Oracle, all you have is the provided high level demo. As far as I know Oracle doesn't sell maps directly but other companies sell them (you can also use Google Map if you buy an API key). Look what Andrew posted... (or Google for it)
  • The separate use of a "normal" webserver is often used as simple proxy to give a nicer URL to your OBIEE (without port number), doing SSL offloading or caching CSS/JS/images to "improve performance". For this last need you must already have a super busy server (I mean lot of concurrent users etc.). For the first need it's…
  • Well, it's not completely wrong: as said you can open with a newer admin tool a older RPD, but you can't save it as the old version. As soon as you save the RPD is "upgraded" to the Admin tool version. So open yes, save no.
  • Opening and making changing it's fine, just do not save or your BI server will not start anymore ... Never ever try to use mismatching server and Admin tool versions. Yes, there are people who will tell you that there is a way to downgrade the RPD etc., but why to look for issues when you can have many admin tools of…
  • If you open your group while in the "Result" tab of Answers and save it the group will be saved as expanded and when you open the analysis the group will be open. That's also the reason why you must never "play" with your analysis in the "Result" tab when testing but only in preview as what you do there will be saved in…
  • Hi, A quick one: did you unchecked "suppress" and select "repeat" in "Column properties" > "Column format" > "Value suppression". As you say in the physical query there is no distinct it means the physical query return the duplicate? Then it's only the analysis hiding it (that's why I point first to the "suppress"...
  • You got the "technical" answers already, so I would like to give you my point of view on the "requirement". Abdul Kather Jeelan wrote:... a requirement where we need to send a report as mail to a Manager email ID in 'TO' and Deputy Manager ID in 'CC' That's not a requirement but somebody whining on a fake requirement.…
  • Hi, As far as I remember 11g (don't have one in front of me right now) it's not something you can manage in the UI and for sure (I would say) not a per prompt setting where it's available for few and disabled for others. Your problem I would first say it would be better solved by design: have a different design of your…
  • Happy to read that So can you do a last thing and close the thread? Still This question is Not Answered. for now ... PS: and maybe also few words on your final solution, just to give the full story to somebody else having the same questions in the future
  • 3250772 wrote:Is Chrome 54 certified with the version of OBIEE that you're running? yes I would say "maybe" ... Chrome 54 was released in October 2016, your bundle patch is October 2014, so there can be things which changed in Chrome 54 and not working with you bundle patch anymore... (I'm not saying it's the case, but you…
  • That's why I asked for the "exact version" of OBIEE, so bundle patch included. Chrome support had issues in 11.1.1.7 because of Chrome updates and various bundle patch fixed them (here is where @rmoff was going with his questions).
  • Hi, You are talking about applications but this is just your own definition and segmentation of a single OBIEE instance, these applications doesn't reflect on the server as independent things. That's why the BAR will contains your full OBIEE and when you import it you import the full OBIEE (ok, you can import only some…
  • Hi, To get some answers you must give something more ... Exact version of your OBIEE, version of your browser, some details of what the chart is doing (displaying 10 points or 10'000'000'000). Also do the common debug processes (clear browser history and files, test different browser etc.)
  • Did you try conditional formatting based on your cell value? It's in the properties of the column.