| Thread | Last Post | Replies |
|
| Cube processing but not showing data | 09 Jan 2006 17:27 GMT | 1 |
SQL 2005 SP3, AS 2000 I have a cube that is processing but is not showing any data when I browse the data. The fact and dimension tables have data and there are no null measures or fields in any of the tables involved. It will process without any problems.
|
| Programatic cube partition creation? | 07 Jan 2006 10:17 GMT | 1 |
How can you programmatically create cube partitions? I have a cube that is 3.2GB in fact data size and a year should contain about 35GB of fact data. I would like to partition it into several slices, however I do not want to create 50 partition through the GUI. Help me ...
|
| BI Accelerator in Slq Server 2005? | 07 Jan 2006 10:14 GMT | 1 |
Has the BI Accelerator tool been dropped from MS or does anyone know of any plans to "upgrade" this tool to Sql Server 2005? We are working on a BI project where we would like to use the BI Accelerator to help generate the schema and data movement and would like to use Reporting
|
| Measure change updates in Fact tables | 04 Jan 2006 08:08 GMT | 3 |
Is there an industry standard method to populate Fact table columns with the amount of change of a measure from one row to the next? I have a FactSubscriptions (1 row = 1 week), and I wold like to have a column of the price change from the previous week.
|
| Moving data to data warehouse | 03 Jan 2006 05:58 GMT | 1 |
I have data in SQL2000, Access, and MSDE 2000. I am trying to move the data into a data warehouse (SQL2000). I am thinking of using replication tools to get the SQL and MSDE data in the warehouse but how do I get the Access data into the data warehouse? The Access data is ...
|
| database for datawarehouse | 03 Jan 2006 05:57 GMT | 1 |
I'm doing a course in datawarehousing. I need some dataset to make a project. Does anyone know where in net can I find datasets appropriate to create datawarehouse? Thanks all
|