all groups > sql server data warehouse > october 2004 >
You're in the

sql server data warehouse

group:

BI Accelerator: problem with current day setting



BI Accelerator: problem with current day setting Eugene Frolov
10/26/2004 3:45:42 PM
sql server data warehouse: Hi, All!

I'm experimenting with MSSABI and look this problem - after running
SetCurentDay.dts package every measure values mutiplied by 6.
Here is my steps:

1. Create Analytical, SM and staging databeses with Analytics builder
utility for SMA template (unmodified).
2. Manualy run Master Import DTS package for loading sample data in Satging
DB.
3. Manualy run Master Update DTS package for loading sample data in Subject
Matter DB (with gbManualProcessDim and gbManualProcessFact set to -1 for
automatic processing disable).
4. Manualy run processing of Sales cube in Ananlytical DB and browse data
after its finishing.
Measure Actual Invoice Count is 2843 for 2001 year (Time.Standard dim -
in rows), calculated members in Time.Standard dim - empty due to current
day is not set.
5. Manualy run SetCurrentDay.dts package with gsCurrentDay = '10.05.2001'
(October 5 2001)
6. Again manualy run processing of Sales cube in Ananlytical DB and browse
data after its finishing.
Measure Actual Invoice Count is 17058 for 2001 year (Time.Standard dim -
in rows), calculated members in
Time.Standard dim have some values.

This behaviour fist time was occured in my custom Analytical app.
constructed using MSSABI, the standard template (Sales and marketing)
behaviour is the same.

Where is the problem - is MSSABI or I'm doing something wrong?

Re: BI Accelerator: problem with current day setting rsada
11/19/2004 10:46:55 AM

Hi

I have already seen this problem a while ago. Checkout

http://www.webservertalk.com/showthread.php?t=895520

I don't really understand what the guy that replied means by "Settin
the all tu current".

What I did at the time (and of course that is not the solution) was t
remove the Weel.Standard dimension from the cube.

Did you found a solution.?




[quoted text, click to view]


-
rsad
-----------------------------------------------------------------------
Posted via http://www.webservertalk.co
-----------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message447789.htm
Re: BI Accelerator: problem with current day setting Eugene Frolov
11/22/2004 9:17:53 AM
Hi!

Checkout this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;834285.

Data in cubes become correct after delete ALL date dims exept only one with
custom rollups.


"rsada" <rsada.1fzsd0@mail.webservertalk.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:rsada.1fzsd0@mail.webservertalk.com...
[quoted text, click to view]

AddThis Social Bookmark Button