in addition to @Sherry George's link ... here's an example of what Kimball describes ... Scroll down to Accumulating Snapshot ... Facts about Facts: Organizing Fact Tables in Data Warehouse Systems Key to remember: ONE ROW represents ONE INSTANCE of the process.

In the future let the user dictate WHAT not HOW ...

Make the Count the bar and the Cost the line ... will help to stave off the impossibility of 'Headcount < 0' impression.

Perhaps an LDAP strategy of moving disabled accounts to a disabled group out of the active group(s) [in addition to marking them disabled] ... then you are pulling only from the active set.

Not at a day for archiving ... use the OS to move based on creation/modification dates

* Archive functionality is not designed for entire catalog * this functionality can be called from the command line * this functionality can be run against a single folder in the catalog * runcat.sh can also create/delete a folder in the catalog So you could write a script that uses the catalog manager to create a folder,…

OBIEE 12c multiple instances - Red Stack Tech

I would suggest you not try to customize the UI with code ... rather, you can let the user pick their dates and you can have a small analysis showing the days between the dates picked ... conditional format it (red/green) or show a message. No need for custom code.

Please mark the helpful comments and the correct answer. Glad you got it working!

The OOTB appsand sampleapp/sampleapplite catalogs have spaces ... I don't think that is your issue ... there has to be special characters that are getting in the way ... if you think your shared folder is solid, try with that by itself ... it may be that a user has a weirdly named folder under their MyFolder ...

I'm not sure it isbalking at the space, but rather characters like it is specifying in the document: 1. %2f (equivalent to "/") 2. new+folder Do you have any of the above in your sub folder structures?

You can use a triggered and bursted BI Publisher report to do this ... if you want each PM to get their own project details (provided you have the connection in the data that supports it too).

Make your data feed: DISTINCT name appt date appt key OR name appt date appt time appt key rank() over (partition by appt key order by appt time) as rnk WHERE rnk = 1 Using OBIEE as a data pump is sub-optimal ... there are much better ways to do this.

Opening the catalog offline or online?

what does the current DB connection string look like? Are you trying it with a SID and not a Service Name?

You can put the variable names and their values in a Narrative view (then you can lay out the information in HTML the way you want to see it) ... then using 'act as' you can login and see what a given user is getting as the values for their session (or you can allow them to go to a dashboard which shows them their current…

Do you have Direct SQL requests going on?

The documents included with SampleApp VM give the instructions to set up networking and connect you client tools to the VM. http://www.oracle.com/technetwork/topics/virtualization/whatsnew/sav607p-deploymentguide-3122964.pdf

Then please mark the comments that were helpful and mark the question answered - helps other who are searching with the same issue.

Please mark the question answered ... helps those with similar issues find working solutions.