You could also create an ASP page that would connect to the table in question and basically do a Response.Write for each of those table based HTML entries.  This would...

You need to add BEGIN and END around the blocks of code inside of your IF and ELSE statements:

IF {condition}

BEGIN

 select ...

 UNION ALL

END

ELSE

BEGIN

...

END

I see what you're saying...  Very creative.  It would work for a small implementation with just a few dimensions and few rows loaded into the cube.  But, I would never consider...

I believe the problem is in viewing the cube and not the actual data mart table.  Most cube browsers will show every dimension member whether there is data or not.

You're...

Glad I could help!

Ok... so the problem is that your levels are built as follows:

Rollup1

      |-----Rollup2

                    |-----Rollup3

                                |-----Rollup4    

                                            |-----Rollup5

                                            ...

                                                           |-----Rollup8

                                                                       |---- Account Level

I've experienced this same problem before... but in...

How is your unbalanced hierarchy setup?  Is the account number always at the same level or does it appear at the level immediately following it's parent?

Either way, it should display...

Vijay,

I have to say it's been a very long time since I've used Crystal.  What it comes down to is that there is a NON EMPTY parameter in MDX.  Crystal...

Even if you add an index, it will likely still do a table scan since you are joining to a user defined function.

If tblcommunicationsSent has 5+ million rows then the culprit is the join against the UDF.  It's going to be doing a table scan because the UDF doesn't have (can't have)...

What are you using to display cube data?  If writing MDX you can use NON EMPTY.

It probably doesn't help that you are joining to a UDF, but check to be sure you have an index on the following fields since you are doing a join:

I've used Visio, ERWin, ER/Studio, and quite a few others.

By far, ER/Studio is the best tool out there.  Embarcadero has a free trial available for it... or at least they...