Search results for query: *

Hi Flybridge, Coming in a bit late here, but NULLS may be the issue. If you concatenate and one side contains NULLS you could end up with a NULL answer. This may happen in more than one place giving non unique members. Trying concatenating with a coalesce around each attribute. There again...

I would have thought the easiest way, would be to create your dimension via a view along the lines of: Create view StoreDimension as Select * From DimStore s Where exists (Select 1 from FactTable f Where s.store_id = f.store_id) Only downside is that the dimension isn't necessarily...

Hi BSGGod, I know I had similar issues in Crystal Reports a couple of years back in getting multiple Pie Charts on one line. However, from what I remember it was a case of perservering with the "Charts per Row" slider and eventually it took. Other modifications would then often knock it back...

Hi BSGGod (Simon), We have had a bit of a result since the post in that we have tested the Active X viewer as opposed to the DHTML viewer that we were using. Mind you we had to apply a patch to enable the option to switch viewers to come up in user preferences. This has given us the ability...

Sorry in advance for the length of this post, but I would really like to receive comments from other users/developers on some issues we are having with Crystal Analysis 9. We have recently rolled out a number of simple CA9 worksheets, via CE9, connecting to Sql Server OLAP Cubes. Our user base...