Search results for query: *

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...

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...

I'm sorry MDXer but the choose table to base fact table dialog box does not show views, only table. UGH. How do you point its source to a view in Analysis Manager? Thanks, Jeff

Hi, Yes, I have similar problems with my totals changing when I added new dimensions. I believe it is because a fact table foreign key is not found in the dimension table so that row is not counted or processed. Sometimes I get a changing number of rows processed after I add a new dimension...

Hey ALL, That's great you can source facts and dims from views. But how? I'm using SQL Severe 2000, when I go into Analysis Services and use normal approach, it only says pick table that will be source for the fact table. Nothing about views. Is it cause I'm using a wizard? Thanks, DWArchitect

Thanks,for the code lookup tip. I wanted to avoid building my own dimension lookup. Sounds like AS will handle this for you. As far as sourcing a fact table from a view, I have not seen any posts on this and have not been able to figure out if it can be done. DW Architect

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...