We have an issue we are experiencing and are looking to see if you may have
seen this type of situation before.

We have a common table called Global_Dim_Rollup which has dimension
information for several of our small dimensions (e.g. Gender, Payment Type,
Age Group etc). The column rollup_cd is used as the unique identifier along
with dimension_nbr.

If we build the dimensions from this table and put a filter on the dimension
to only pickup values with the corresponding dimension_nbr in our table the
dimension are created fine.

When we attempt to process the cube we are experiencing issues as it appears
the SQL is not generated correctly and the filter information provided in the
dimensions are not being utilized. This results in an empty result set.

Is there anyway to accomplish what we are trying to do in Analysis Services
2000 without having to break up this table into multiple smaller tables or
creating a bunch of views? I am getting pushback from our DBAs on creating
these structures on the database as they feel it is a flaw in the tool.

Thanks in advance,
Sam.

1) How are you specifying "and put a filter on the dimension to only pickup
values with the cooresponding dimension_nbr"? What field or property are you
using in Analysis Manager to specify this filter?

2) When you say that ithe "dimension are created fine." what do you mean?
How can you tell that the dimension is created fine? If you run SQL
Profiler, do you see an SQL being generated when the creation is being done?

3) I need the SQL statements between when it is "created fine" and when "the
SQL is not generated corrected".

With info I think we should be able to get to the bottom of this. . .

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Prasad" <Prasad (AT) discussions (DOT) microsoft.com> wrote