Hi

Analysis manager won’t let me create dimension unless fact table filed has
value init.
Other words, how do I create MT dimension(dimension without member)
thanks

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200604/1

In article <5e6cd6213d345@uwe>, u20487@uwe says...
The short answer is that you can't.

The long answer is that you need to set up a dummy column. When I do
this I usually create a view with a constant in it and use that view for
my fact table and then link the dummy column to one of the members in
the dimension.

I assume you are creating this dimension to hold calculations (like
"YTD", "YTD last year" etc). I usually create one member called
"current" or "actual" with an Id of 1 and then generate a constant of 1
in my fact view.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell