I so wish they would update the system to use relative paths. Doesn't seem like it should be that hard to do. Put in a request for this many many years ago but hasn't happened. Scott

Thanks for the feedback, I'll talk to our VM guys about why our OBIEE 11g vm is so much slower than the physical machines. It's "supposed" to have the same memory and cores, etc. but maybe not. Appreciate the feedback - thank you! Scott

Actually, it looks like the WLS ports and managed server ports are also in the 9500 range instead of the old 7001, so I think we'll be ok. Anything else tricky I should be aware of? I appreciate the help everyone - thanks! Scott

Hi all, I would use a VM, except we're also going to try to get some performance information, and in the past I've seen OBIEE perform MUCH more slowly on VMs then on actual servers. We are on Linux, and I intend to install in separate directories and keep the OBIEE port numbers different. I'm more concerned about the…

p.s. the SQL being produced using the evaluate is correct: SELECT SUM(T940405.ANNUAL_PAY_RATE) AS c1, T939141.DIM_DATE_KEY AS c2, TRUNC(months_between(T939141.DIM_DATE_KEY, T938790.BIRTH_DATE) / 12) AS c3 FROM DIM_EMPLOYEE_DETAIL T938790, DIM_DATE T939141, FCT_JOB_JED T940405 /* FCT_JOB_Day_level */ WHERE (…

Hi all, just to follow up on some details in my original post that seemed to be too vague: 1. On our database, I can perfectly calculate the age as trunc(months_between(reporting_date, birth_date) / 12). I simply want OBIEE to be able to call this same function 2. Users can select any valid date in the "reporting date"…

Hi all, just to follow up on some details in my original post that seemed to be too vague: 1. On our database, I can perfectly calculate the age as trunc(months_between(birth_date, reporting_date) / 12). I simply want OBIEE to be able to call this same function 2. Users can select any valid date in the "reporting date"…

Gotcha. This is actually a very unusual situation...first time I've run in to a case where 5+5 doesn't equal 10... Appreciate the help - thanks! Scott

Hi Christian, not sure I consider this as "smoothing over RPD deficiencies", but more of just adapting the principle of saying that any time you have multiple facts with non-conformed dimensions, we'd want total levels. Using out of the box campus solutions and there are a ton of dimensions....as we add additional ones and…

Yeah, I've been looking for a solution which is both a) simple to implement / maintain and b) calculates everything properly, and haven't hit on the right combination yet. At least this option gives me some other alternatives to try. Thanks! Scott

Hi Christian, thanks for the info. Have you used this in the past, and has it worked ok? I'm assuming when turned on, then I simply need to supply an LTS that hits at the lower level which doesn't aggregate up, as well as one at that next level up the food chain (in my case, level 3 doesn't aggregate to level 2, but level…

p.s. as a follow up, the RPD builder's guide doesn't exactly have a detailed description of what this option does, what the use cases are for not using it, etc. Just a single sentence that mentions this option....and manages not to say anything useful. Thanks, Scott

Well, what I ended up doing (no clue if it was correct or not) was to make a copy of r-package-install-linux.R called "scott.R". I then edited out the entire section about proxy stuff, just leaving the function installpackagecustom and all of the lines below that. Then from the command prompt I ran: Rscript scott.R This…

Thanks Gianni, I appreciate the help. I'll give this a try and see if I get anywhere. Thanks, Scott

I'm not sure I understand the issue. Would you not simply create the metrics in the RPD, and then display them on the dashboard? And whatever date the user picks, the metrics would automatically calculate? Feel like I'm missing something. Thanks, Scott

I would implement a fact table that just contains the transactions that happen for customers (i.e. your couple of thousand of transactions per month vs. your 9 million "customers"). Then you can create metrics which show the transactions by month, or you can create a "life to date" type metric that would sum over time.…

Hi everyone, just to clarify, all of the following scenarios are legal: 1) Class A capacity = 10, class B capacity = 10, cross listed class capacity = 20 (i.e. "you can have up to exactly 10 people from class A and class B") 2) Class A capacity = 10, class B capacity = 10, cross listed class capacity = 15 (i.e. you can…

Kimball suggests using a numeric instead of a date because if you need to have date dimension values of "Unknown", "Not Applicable", etc. and you're using a date field you have to start doing wacky things like assigning bogus dates of 1/1/1900 to mean "Unknown", 1/2/1900 = "Not Applicable" etc. And if you do that, you also…