Hi,
I am attempting to retrieve the name and datasource of the
writeback table (for a write enabled cube in Analysis
Services) using DSO and/or ADOMD. I sucessfully retrieved the name and location of the datasource using the following property:
DSOCUBE.dataources.item(1).connection.defaultdatabase
Because a cube can have only one datasource (the cube's
partitions can have different datasources than the cube's
datasource), I assume that the writeback table WILL
ALWAYS be a part of the database defined by the cube's
datasource. I was unable, however, to retrieve the underlying name of the writeback table.
Can someone please (1) suggest a method that will allow
me to retrieve the name of the writeback table and (2)
confirm that the writeback table will always be found in
the cube's datasource (not a partition's datasource).
Many thanks,
Raj C.
I am attempting to retrieve the name and datasource of the
writeback table (for a write enabled cube in Analysis
Services) using DSO and/or ADOMD. I sucessfully retrieved the name and location of the datasource using the following property:
DSOCUBE.dataources.item(1).connection.defaultdatabase
Because a cube can have only one datasource (the cube's
partitions can have different datasources than the cube's
datasource), I assume that the writeback table WILL
ALWAYS be a part of the database defined by the cube's
datasource. I was unable, however, to retrieve the underlying name of the writeback table.
Can someone please (1) suggest a method that will allow
me to retrieve the name of the writeback table and (2)
confirm that the writeback table will always be found in
the cube's datasource (not a partition's datasource).
Many thanks,
Raj C.