Hi,

I'm having a problem with the SetCurrentDay DTS package
of the BI Accelerator.

I'm loading a set of data using text files therefore I'm using
Master_Import.dts and Master_Update.dts unchanged. Then y run
the VBScripts that are alsgo generated by Accelerator
(VAMPanorama1_Load_VAMPanorama.vbs).

This loads the data from text files into the Staging Database and SM
Database, and also runs the Set Current Day package with a fixed date of
"2001-12-31".

The problem is data for the year of the Current Date is multiplied by a
factor of six. Now, when I run SetCurrentDay Package Alone, to try to
set a new date (say "2003-07-01") either opening the package in
Enterprise Manager and changing the global variable, or using DTSRUN
utility I get the same problem. The data es multiplied by a factor of 6
for the year 2003 and data for 2002 and 2001 shows up correctly at the
year, qtr and month level.

Has anoyone seen something like this? am I doing something wrong here?

Any help is appreciated,

Thanks,

Ricardo Sada
rsada (AT) solcominter (DOT) com
ricardo_sada (AT) yahoo (DOT) com.mx

I tried also running one of the sample proyects (RA - Retail Analysis)
and load the sample data to see if this is only related to my particular
project/instalation, but I got the same problem.

If anyone has seen something like this please let me know haw to solve t
workaround it. thanks..

Ricardo Sada wrote:

I tried your workaround (delete the Week.Standard Dim) and
now I get my data right in my Time.Standard dimension. Week.Standard
aggregated ok to the year level though (before I deleted it). How can
this virtual dimension be affecting the

I tried the RA model that comes with Accelerator and got the same
problem so this seems to be common.

what do you mean by "select the current year in
the Time.Standard dimension, and also select the current
year in the Week.Standard dimension"??. are you modifying the
custom members formula? or you mean in an MDX statement?.

Thanks.

Unfortunately, I only mean "select the current year" in
the user interface, like Excel.

I'll continue to work on this problem until I find a
solution. Can we make it up that you'll post the fix here
as soon as you have a solution? I'll do the same.

I may open an incident with Microsoft if I cannot find a
fix.
Although I am a registered MSDN Universal subscriber and
as such they should respond to my postings within 2 days
this isn't happening.

I though ALL dimensions were shared in BI Accelerator by design.
I remember reading this in the documentation.

At least in my Accelerator cubes there are no private dimensions.

I'll keep on investigating this and post here if I have some news.

John wrote: