Please post physical SQL that get's sent back to the database ... I'm wondering if you have data type issues ... why logically casting the start date?

Check your settings for timezones ... also post the WHERE clause of the query, I'll take a look at that too.

I'll let a hijacking go once ... your lucky day! Yes, you will need to download the VM and then you have it all. OBIEE Samples I'd recommend the one for the version of obiee you have, then next one up (if you have 11.1.1.7 then get the 11.1.1.9) and the new one 12c ... then you know what's what when and if you get…

I don't misunderstand you ... there's a radical shift in the UI for 11g versus 10g. (And there's a good deal of change in the 12c version as well.)

11g has a new user interface ... if this was a requirement and a must have, the choice to upgrade over-rode that. Having said that you could create a menu like they have in the Sample App: http://slc02ojq.oracle.com:7780/analytics/saw.dll?dashboard&PortalPath=%2Fshared%2F01.%20QuickStart%2F_portal%2F1.00%20G… user: prodney…

please

Let me google that for you

Any explicit deny of access to these reports? If so, that user might be in one of those roles and thus is being blocked.

Take a look at implementing a logical version of your measure using the aggr rule of LAST()

Your use of information drives your physical data model design ... you need a fact table that is keyed to a dimension that has each iteration value ... you will calculate each row and the delta to it's corresponding row ... now you can show either value or both.

Put the textual representation of the week in your calendar dimension for each day ... a well-formed calendar dim will serve you well time and time again.

use a key of 0 (ZERO) in your dimension for unassigned ... then you preserve the inner joins AND it's easier to find the rows in your table maintenance when the key needs to be set ... set up all your dimensions like this where you might have an unassigned key relationship. IE Status_Dim Key | Status 0 | Unassigned 1 |…

Have your BI admin get them from there or has been pointed out - have a linux admin pull the files from the file system. biee_client_install_x64.exe for 64-bit Windows biee_client_install.exe for 32-bit Windows

Get the client tools from your OBIEE implementation ... then you have the right patch level.

That's the one-time solution ... USE of information drives design. Spend the effort and do it right; then it will perform better and is much more usable.

I think you'll be alright if both the BI Server and Presentation server are running to stop/start/restart the Scheduler ...

see section 8.1 - Shell scripts OBIEE 10G - Linux OEL 5 x86 Installation version 10.1.3.4.1 [Gerardnico]

You need to model the hierarchical relationship between account and group account ...

The only way to do it non-logically is to have a physical snapshot table that reflects the To-Date value as of last ETL run ... as mentioned - a lot more work with no added benefit!

I'm in PA as well ... email me thomasdodds AT hotmail dot com ... I'm no longer in consulting, but can give you recommendations.