Please may I have your assistance with the following error I get when I attempt to process a cube.

A member with key 'www.utarget.co.uk' was found in the fact table but was not found in the level 'Device Name' of the dimension 'Server'

The above is just an example I get this error multiple times for different keys
The dimension server consists of the table devices which has the level 'Device Name'. The above device name as well as the others are in the tables.

I have reprocess the dimensions and the cube with no success.
Also optimization was NOT run on the cube. I've tried this with optimization on and it was worse.

My fact table is approx 70 million rows my dimensions are 'shared'

Your help on the above would be greatly appreciated

John

*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse....98d55c04dccc63
*****************************************

You really need to check you underlying data source for this.

If you want to avoid the error then you could filter the fact data by
the dimension or include the "rogue" dimension members under some other
parent classification to distinguish them from known server data in
your dimension.
e.g.
Top Level
- Parent of known members
- - Server a
- - Server b
- Parent of Rogue members
- - Server c
- - www.utarget.co.uk

This would involve a pretty low performing dimension process but you
would get all of the values and be able to identify which servers are
not in your dimension.

Hope I've understood your question and not over complicated it but
check the fact table / dimension referential integrity (if you have
any) first as your error may be valid.

Steve

Thanks Steve. The issue was with the Server dimension, it had a sub level which was not consistent. I introduced the sub level because of the 64000 limit. I set automatic grouping of this sub level however found that the aggregation was based on this grouping which is not what I really need. I would like to see the measure per lowest level however this from my limited knowledge does not look possible?

*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum....rver-olap/4564
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse....871c48ce4d7d11
*****************************************

Rather than have the automatic grouping could you put something into
the dimension that would have more meaning to yourself or even make
the level alphabetised based on the first digit or digits of the
server.

When you say the aggregations are based on the grouping, are you saying
you can't drill down to the server leaf level?

Some device names are ip address with [] round them. I kept getting an error when running an MDX query for this particular level. My initial thoughts was a limitation in the sub level. I've since discovered that if the closing bracket ']' is part of a symbol name then u need to use double ']]' this resolved the issue. As u can see I'm a novice in MDX.....The next challenge is to return the top 10 device names based on the measure, volume for a given time slice...

Many thanks for your help.

*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum....rver-olap/4564
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse....09ce5e6b42423e
*****************************************