Similar as before, you model your tables making the joins based on your conditions between xxesc_pa_timecards and xxesc_forecast_time, for the "Total_Actual" you can add a "by" in the formula.

Hi, Your SQL can't be used in the RPD just because if you use it you are making the whole concept of RPD useless (and paying an OBIEE license when SQL Developer could do the same for free). Yours is probably the most simple model you can have: dw_project_d is conformed dimension and dw_plan_time and dw_pa_hrs are 2 fact…

And where is time spent? What does the system do when it's taking longer than 11g? These are the key element to understand what can be done to improve your current situation ... So start analyzing your logs to get these info.

Interesting, but it's definitely something at the browser level (the way I understand it). And as you did, deploying a copy of the JS file "locally" on the server, is always the way to go just to be sure of what the library does (guess what happen if the D3 site is hacked and their library takes your data from the page and…

Yes, you will have a single column in the logical layer and presentation layer (in the picture above it's the "Source" column, "Column A" is just there as random column returning some other data...

Hi Sam, Just to make sure, what kind of tutorial / blog / document are you following for the install? In case you don't have any have a look at https://realtrigeek.com/2016/04/15/installing-obiee-on-linux/ or also Installing OBIEE 12c. Part 1: Prerequisites - Red Stack Tech . Your log complains about some JDBC ... but not…

Hi, A grand total calculated automatically by OBIEE because you enable totals on your pivot will not allow you to do that as you don't have a place where to enter a formula for it. It's calculated automatically based on the aggregation rule set and not a custom hand written formula doing * 40 .

Hi, You seems to have the good model to solve this easily ... So you have 2 physical tables, going into 2 logical table source into the same logical table. Look at this picture, it's what you can try to do it. The idea is to add a new column in your logical table (in my picture it's the one named "Source"). This new column…

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.