HI Sherry, I did that too.. I did both, (in the XMLP section) changing it to zero (supposed to remove all limits) and increasing it to a very high number (2048000), all to no avail.

You can also default in the current date or create a repository variable that you can then default to in your prompt.

Thanks Thomas, it is finally working. One more final step. I had to explicitly declare that FAct Item Master Update date also mapped to the Item Master Fact (with an inner join) for the Item Master Create date.

Thomas, You know, you may actually be helping me solve this issue but not in the manner you are expecting. :-) I think what I am saying next may be showing where I am messing up. For my column mapping for the Item Master Update table.. I have mapped only the column Item Update date (the remaining columns are mapped in the…

The Item Master Update Date Fact is an alias of Item master Fact and joins to the Item Master Date Dim table on the Item Master Update Date column Both the Item master fact tables are aliases of an actual physical table. I just reduced this part to these three tables, to test canonical time before implementing it. I will…

Here you go

Thanks Thomas, My error seems to be occurring when I want to display the dates in my report. i.e. I get the errors listed above when I select shipped date. If I do not select shipped date my report works fine.

Thomas, this is from my personal experience. I found Windows to work fine in an environment supporting about 200 users. I have since then worked on Linux at two other companies and, honestly speaking, I can see where you are coming from and think Windows would work fine. Linux is supposed to be more stable and nowadays…

Did you try looking at obips.out and sawlog*.out? They are in /user_projects/domains/bi/servers/obips1/logs

Christian, Is there a recommended backup routine and or methodology Ex: Back up xmlconfig file every time you change it. (I'm making it simple but am wondering if there are certain files that should be backed up periodically or before certain deployments) Respectfully Khalid

Yes, I did and the documents talked about 660 mb for weblogic 1.5 g for infrastructure and 1.5 g for the http server, a total of about 3.6 g. Is that the minimum? I thought I was missing something. So, would about 20-30 gb work just fine? We do plan to have 3 environments but would use our test env for training too so it…

Well, the minimum that is required for an enterprise with about 100 users. We'd like it to function properly without hiccups, so planning now for later patches would be sensible. What do you think would be practical?