August 23, 2002 at 6:47 pm
I have a data cube in Analysis Services (SQL Server 2000) with private dimensions only. The cube uses HOLAP storage and the dimensions use MOLAP storage. I have been testing loading and processing the cube and have noticed that when I clear all records out of the fact table and then reload them, process the cube using a full process after the first 100,000 test records and an incremental processing after the second 100,000 records (for a total of 200,000 records in the fact table), the total record count is 400,000. Obviously, when I cleared out the fact table, brought in the test records, the original 200,000 test records that were in the cube prior to bringing in the second test batch did not clear out of the aggregations.
When using the full processing method, doesn't that clear out the aggregations and start over again? If not, what is needed to completely clear out the data cube?
Thank you,
Michael
Michael Weiss
Michael Weiss
August 24, 2002 at 2:24 pm
So I start a refresh data operation on the cube and I get the following error:
Analysis Services Error: Processing Error [Attempt to delete member that is in use]'0000000000'
...where the '0000000000' is the data member in question. Anyone know what causes this? Is this some kind of locking issue? I would be grateful for any help...
Thank you,
Michael
Michael Weiss
Michael Weiss
August 29, 2002 at 4:15 pm
I don't know about the error you mentioned. To clear out the aggregations, you can go to the cube properties (in Cube Editor) and on the second tab the first parameter is the count of rows, there are a "..." besides the number, click there and the number of rows will be tallied again.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply