Oh yeah. should have mentioned that SSAS named calculations is nothing more than the DB engine calculations palced in the DSV. SSAS does not calculate anything really

I suppose these two things are the same.

The difference is that the SSAS would generate a SELECT query and the calculation will be in there aliased with a name, but...

I figured out the problem and will answer my own question so that ppl know.

BIDS DSV replace table feature replaces the table in the DSV and consequently in the DSV...

I don't believe everyone here enjoys smooth BIDS performance when debugging their big SSIS packages.

It just kills me and I don't know what to do...

Please help

I figured it out, but have not solved the problem

There is an attribute with a composite key comprised of two fields and I linked the dimentions to the fact table...

Reading theory...

I meant if you do ANY of that and you care about performance -- then Mr Index is your man

Imndexing is used for Joins, Searches, sorting and filtering and other things.

If you do all of that -- index, if not -- no point.

You are in a wrong phorum...

I just realised that when you create a new dimension using the wizard there are two options.

When using the first option, (Build dimensions using data source) it assigns the name...

Still the question is up. Even if I rebuild the dimensions and combine them in one with multiple hierarchies, HOW do I change the ID of the dimension?

Changing the...

Correct....

here we go.

C# code:

C++;

You are in the wrong place and also your poll is meaningless 😀

It is in your court now. Sorry, but even if the two queries come back once with the same results, the answer is still NO. The reason is consistently...

Lynn Pettis (6/11/2008)

---

To paraphrase what someone else once said on this site, "The proof is in the code." Here is the code:

...

while @LoopCnt < 100

...

Based on the results, the...