Hi Fernando, once you downloaded the .zip file - where exactly did you unzip it? I'm not sure where to go to try the installation by hand. Thanks! Scott

Ok, I "finally" figured this out. Scanning my system for any files called DVML*.*, I saw a .msi file. Ran that "as administrator" and got an error saying that it was specifically blocked from my system by admin policies. Logged out and logged back in as a true local administrator and it installed perfectly. And it did…

Thank you Adam for pointing us in the right direction. Appreciate the help! Scott

Hi Adam, I'm still confused by this and am not sure I see how it's going to work (note, I'm an OBIEE guy, not a weblogic / SSO / web application guy). When we log in to OBIEE, we use a URL that looks like this: https://ourserver/analytics Our SSO sends us to another webpage, where we then have to click the "Send a push to…

Thanks Adam, I'll see what we can do - thanks for the direction, I appreciate the help! Scott

The odd thing is: I thought the DVD product essentially contained a desktop version of the OBIEE server. It "should" be able to do pushdown already... Scott

My wish list would be: 1. Connection to BI server so we can use OBIEE data without predefined analyses 2. Connection to BI server that can happen even through SSL web connections (https) 3. Ability to display on a dashboard 4. Some decent (and/or ANY) instructions on how to use mapping. For instance, maps work properly if…

I wish they'd get OBIEE closer....testing 12.2.1.2.170418 or whatever the latest and greatest is...and still don't even have the ability to have multiple dashboards. Seems like they're a full year behind with syncing OBIEE up with the DVD desktop version. Scott

Hi Christian, note that he said the diagram was a picture of his business model....so I think you're looking at it. Looks like lots of issues here - not a proper star schema, not using business names instead of physical names, etc. Scott

Hi Lamin, yes, I have usage tracking enabled, and have been gathering statistics for years. But that doesn't give the same information as the summary advisor seems to - I can see both the logical and physical queries, but without trying to parse through all the SQL, there's no way to summarize it by dimension / level.…

I suspect you're going to need to update your data model...the requirement sounds simple enough "did the previous event happen within 2 weeks"...but these things are maddeningly difficult to code for. For instance. do you include weekends? Holidays? Leap year vs. non-leap year? Time based calcs are are always a pain. You…

Just curious why your org and product dimensions also use the year / months in their joins? Not understanding why you'd want to have to create a whole new set of orgs / products monthly? If you have 100,000 products, do you end up with a whole new copy of those for every month (i.e. 24 million records - 100,000 per month *…

Hi Christian, no, those are issues which are easy to create on "public instances"...I just didn't realize any public instances are available? If so, that may save me considerable time. Right now working on a pie chart issue that I'm surprised everyone hasn't rebelled because of how badly they are broken (then again, maybe…

I think one of your issues is that the "loan amount" is not a fact that can aggregate over time using "Sum". You'll want to choose Last to get the "ending balance" of the loan. Payment amounts are additive over time so those facts should be ok. Note - OBIEE doesn't do "last" the way I want it to. Instead of figuring out…

Thanks all, I thought I had read that the .bar file would also migrate settings out of the NQSConfig, instanceconfig.xml, etc. I'll try to find the reference I was reading and call it out here, so we can either shoot it down as not true, or correct my poor interpretation of it. In my case, I'm just trying to get a "clean"…

Hi Robin, sorry didn't see your question until now. Use case is pretty dumb...Oracle doesn't seem to like to work on SRs unless you can reproduce a use case using their sample data...so when possible I like to keep the sample app around, just so I can reproduce issues and spur Oracle to get to work Easiest to do that on…

Ok, thanks Robin, that's what I was afraid of. Can definitely work with just using archive / unarchive for now, was hoping for something faster / easier, but it should work. Can't wait until Oracle finally allows multiple service instances...wonder how far off that is. Thanks! Scott

Christian - thank you SO much. I completely thought this was an OBIEE problem, not a Linux NZ odbc setup problem. Once I added the correct environment variables, everything is working perfectly. Thank you VERY much! Scott

I have found the LAST aggregation method to be extremely poor performing. In essence, if you have data at the "day" level and pull back the "Last" value for a year... it pulls back data for all 365 days, and then only keeps data for the last day that contains data. This is because LAST means "Last day that has data", not…

Hi Christian, is there something in the code that prevents them from doing this? One note, in the past I've used the XML find / replace functionality in the catalog manager to update the absolute paths to the new locations. This works pretty well...but I'm always hesitant to use it. For the most part, we have folks develop…