Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: DWArchitect
- Content: Threads
- Order by date
-
NULLS IN FACT TABLE
Hi, 1. I have a fact table where some FK's to the dimension tables are null. I've added a NULL value to the dimension table, but still my counts are not adding these fact records. How can I include the nulls in my cube totals? 2. Can I have two columns in the fact table point to the same...- DWArchitect
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Is there a command history in SQL Query Analyzer?
Hi, I am using Query Analyzer to submit ad hoc queries to SQL Server. However, I have not been able to find out how to recall SQL commands that I have entered. Is there no history of commands. I don't want to have to retype all of my statements. It seems incredible that there is none, but I...- DWArchitect
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Fact Tables based on a View
Hi, I have two fact tables that join in a one to one relationship. I want to use the joined tables as the fact table, can Analysis services create a fact table from a view or materialized view? it seems to only let me choose a table it doesn't show any views. Also, can I rename a dimension...- DWArchitect
- Thread
- Replies: 8
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
