Dimension creation manually issue

I have created a new dimension manually from a project.But when I rebuild,deploy and process and view browser for that cube, I couldnt see the new dimension from the list of dimensions. Under what condition should the new dimension 'relates' to the cube?

Thanks.

Regards

Alu

You have to add it to your cube and then define right relationship between dimension and measure group|||

You do this in the dimension usage tab in the cube editor in BIDS.

Right click on the dimensions and choose add cube dimension

HTH

Thomas Ivarsson

|||

Thanks.

Regards

Alu

Different FillFactors for different partitions?

Why is fillfactor not a recognized option on alter index rebuild
partition. I'm partitioning my data by month, I'd like to set the
fillfactor to 100 for old partitions, but put a lower fill factor say
60% for this month so that I don't have to worry about page splits for
incoming data. I'm in a realtime etl environment, so a sliding window
is not going to do it. Please advise.
ALTER INDEX IX_MyIndexKey ON dbo.tblMyTable REBUILD PARTITION=91
WITH (FILLFACTOR = 60,
PAD_INDEX = ON,
ONLINE = ON);
GO
Msg 155, Level 15, State 1, Line 2
'fillfactor' is not a recognized ALTER INDEX REBUILD PARTITION optionIt's a known issue:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=242025
Please cast your vote so that it will move up on their priority list.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"dba" <bryanmurtha@.gmail.com> wrote in message
news:1186660216.374134.172540@.g4g2000hsf.googlegroups.com...
Why is fillfactor not a recognized option on alter index rebuild
partition. I'm partitioning my data by month, I'd like to set the
fillfactor to 100 for old partitions, but put a lower fill factor say
60% for this month so that I don't have to worry about page splits for
incoming data. I'm in a realtime etl environment, so a sliding window
is not going to do it. Please advise.
ALTER INDEX IX_MyIndexKey ON dbo.tblMyTable REBUILD PARTITION=91
WITH (FILLFACTOR = 60,
PAD_INDEX = ON,
ONLINE = ON);
GO
Msg 155, Level 15, State 1, Line 2
'fillfactor' is not a recognized ALTER INDEX REBUILD PARTITION option