| Thread | Last Post | Replies |
|
| Indexing/Unique Key | 04 Oct 2005 10:55 GMT | 3 |
This is my first post here, hopefully you folks can help me. I have the typical Invoice Header and Invoice Detail Fact Tables. I’ve read that you should declare a clustered index on all of the foreign dimension keys in a fact table (for SQL Server).
|
| SQL Server 2005, UDM and Business Objects Universe | 04 Oct 2005 10:02 GMT | 2 |
I'm wondering how Business Objects will integrate with SQL Server 2005. In particular, since the features of UDM (Unified Dimensional Model) and BO Universes seem to be overlapping, will BO be able to exploit all the features of the UDM?
|
| How to create such a member on dimension? | 03 Oct 2005 22:59 GMT | 2 |
I have a measure type dimension with 1 - 5 types. I want to calculate sum of measures with type of 3 and 4. So I will have 6 types. And I want to show sum of measures on column, and 6 types on rows. how can do this?
|
| Please help | 03 Oct 2005 02:34 GMT | 2 |
Tab1 and Tab2 has the following info.ID column in Tab1 and Tab2 has matching values. Tab3 should have the info as below. Tab1
|