Hi All,
I'm creating a Dimension using DSO.
All is fine as long as the dimension has only one
sourceTable.

However, when i have more then one sourcetables, and i'm
using the FromClause and JoinClause properties, the
dimension is created and the 2 tables and join apears
at the design of the dimension BUT when i try to process
the dimension i get an error and it seems that the sql
that is built for the processing , is wrong (one character
of one of the table names is missing).
HOWEVER, if i SAVE the dimension and then process it,
then all goes well...

Tnx for the help..
Yaniv

A technique that I frequently use is to run the Metadata scriptor which is
available on the SQL Server 2000 Resource Kit. If you point it at a cube, it
will generate a VB program which will re-create the dimension. So the
sequence of steps that I use is:
1) Delete the dimension.
2) Re-create the dimension using Analysis Manager.
3) Run the metadata scriptor against the dimension to generate the VB
program (let's call it VB1)
4) Delete the dimension
5) Run your application which attempts to recreate the dimension using DSO
6) Run the metadata scription against the dimension to generate the VB
program (let's call it VB2)
7) Run windiff against the two VB files and see what the differences are.
My guess is that you will see that Analysis Manager has setup some property
or properties that you aren't expecting.
Hope this helps.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


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

Tnx dave - that realy helped !!