all groups > sql server data warehouse > july 2003 > threads for july 1 - 7, 2003
Filter by week: 1 2 3 4 5
Virtual cubes
Posted by Richard at 7/7/2003 1:56:41 PM
I need help. I'm working with SQL Server Analysis
Services 2000 and I have a really big problem with a
virtual cube.
I processed the cubes and then I archived the database
without problems, but when I restore It, the virtual cube
is not processed.
Could someone help me with this issue??... more >>
Table design
Posted by Shamim at 7/2/2003 11:24:35 AM
SQL 2K
I am creating a table for holding data used for data wear-housing project.
This table will eventually going to have millions of records.
Planned to have a primary key and proper indexing in this table.
This table will be queried against various columns and will be refreshed
(fill data)... more >>
BI Accelerator Requirements Question
Posted by jreisz NO[at]SPAM msn.com at 7/2/2003 7:41:21 AM
I have been going over the requirements for SQL Server Accelerator for
BI and mostly everything makes sense except the requirement for
Windows 2000 Advanced Server or greater for the relational server
(Staging, Subject Matter Database, BisoCatalog) in a production
environment. The requirements ... more >>
Error - Exceeded max no of levels in a cube
Posted by Lakshmanan at 7/1/2003 3:06:02 PM
I have a virtual cube which has 4 physical cubes. The
virtual cube has 103 dimensions. while processing it
throws me an error that the cube has exceeded the maximum
no of levels in a cube. I guess the max limit is 256. Is
there any way of overcoming it? Its urgent and can
somebody help... more >>
Loading large FACT Table
Posted by mrwhite NO[at]SPAM lehman.com at 7/1/2003 6:25:11 AM
This is addressed to the well-experienced dimensional model gurus...
I am currently loading a dimensional model of more than 100MM rows of
data each week. The source data is being put in a database within the
database server. I am using TSQL to populate the FACT table and then
run the aggreg... more >>
Aggregation function SUM
Posted by Samuel at 7/1/2003 3:54:02 AM
I want to make summerize of one collumn from a fact table
of a cube.
How can I do it ?
... more >>
|