Well... to shutdown these things just stop the full OBIEE stack .... Most of these features aren't real independent processes. And the memory you will gain by shutting down one of the components will costs you more in missing functionality (based on licensing costs) than than the 200Mb of RAM you get back. The product…

Same browser, network etc. used to compare your working 11g and not working 12c ? Because honestly it sounds strange. First, being you I would definitely download the d3.v3.min.js library and copy it into an analyticsRes folder deployed on your OBIEE (what if D3 site just goes down? Your things stop working for a little…

Hi, Strange requirement I suspect out of the box you don't have a magic checkbox for that, OBIEE can limit values of one field prompt based on another (or all others) prompt but that's always and not based on the value of the first. A possible dirty workaround if you really need that could be to split the prompt into 2.…

Hi, were does your 2 columns (actual and plan hours) come from? Are they in the same logical table? Do you have a value for both columns in the same row? You probably see where I want to end up with my questions but it really depends on your model and where does these 2 columns come from to manage to set the value for your…

Hi, You can't put the UPPER in the variable field name of the filter as it will take " UPPER(Item) " as the variable name instead of UPPER of the variable " Item ". So in the field you simply enter " Item " and then click on the checkbox "convert this filter to SQL" and there in the LSQL field you add the UPPER function…

Hi, Usage tracking as suggested by Satya Ranki Reddy is an option if all your users connected at least once or they don't exist in usage tracking. If your users are stored in the embedded Weblogic LDAP you can access and query it like any other LDAP server, Publisher can use it as source but not OBIEE itself. In that case…

Sorry but ... How is that different from Creating a Measure: Max Sale Amount from Last Three Months ? What's the point in answering your threads if you just open a new one? Please avoid double posting, it makes the forums unusable (just think if everybody post their questions 2-3 times).

Hi, did you try by setting the aggregation to MAX on your sale amount column and filter the analysis on the last 3 months?

And the day you have issues don't even try to contact Oracle for any support and if you post back here start by saying you are using 12c with Java 1.7 so people will just tell you it's not certified .... If you are just setting up a sandbox to look at tool fine, but if you are planning to really using it I would suggest…

As Joel said ... Yes, there are many ways to convert a calendar date into a fiscal one, the question is: what are your fiscal calendar rules? And based on your answer the issue happen when you try to have nicely formatted columns "like FY 2016-1" instead of "01.09.2016" etc. That's why you are supposed to generate it in…

Hi, Do you have your fiscal year and month in your DB table? If not it's maybe the first thing to do: source them in your DB ...

My bad, I missed the "pivot" point and started thinking at table :s (so columns being real columns and not values of a single column) @Andrew Fomin. has it! Switch the right answer to his own.

Honestly other than the JS/CSS unmaintainable and expensive hack I already wrote about there aren't simple workarounds. If you use sections everything will have the same structure. To have different number of columns you would have to build individual analysis, so nothing dynamic at all. You can also of course just build…

The answer for a PIVOT is a bit below, posted by @Andrew Fomin. Hi Jessica, Not really possible ... Every table/pivot for each section value will have exactly the same number of columns as the others, so all your table/pivot will always have all the 5 items columns. You can of course get into some JS / CSS if you really…

What kind of authentication is used on the picture server? In the end your problem is that! Find out how you can automatically authenticate on the picture server so you can just display them ....

Hi, Call your DBA ! ORA 01792 isn't an OBIEE error itself. The database raise the error and OBIEE simply display it, so if you want it to run without changing anything in your OBIEE you call your DBA and ask him to change the setting in the DB. Do a google for the Oracle ORA 01792 to get more info, it seems it can also be…

Hi, The idea of having pictures with a naming standard that you can easily build the link to display it is fine. What is that thing about "service account"? Do you mean that the server hosting the pictures require a login to display them? Because in that case you can't really do miracles .... It of course depends on what…

+1 @Thomas Dodds Look at the certification matrix for OBIEE 12c: minimum supported java is 1.8.0_51, so with your 1.7.0_15 you are a bit .... outdated ... It's a good thing the RCU crashed as at least you didn't really start installing things with no chance to have it working.

A dirty (but really dirty) workaround could be to transform your 2 columns into a single one: concatenating Store Number with some random (impossible to have in your data) characters and than Product Number. A more clean solution would be to adapt your model to be able to receive the "Amount > 10" condition and…

Sorry but ... Why to make it so complicated? I would say you have to store the decrypted value in your DB and just setup a correct security in your DB > RPD > OBIEE objects so that only authorized users can access it. The OBIEE front-end is not a simple table with just few rows and columns, because of all the possible…