N
nzmike
Hi,
I'm working on a .Net 2 WinForms app which allows our B.I consultants to
design starschemas (for our clients) which represent a data-warehouse cube.
As such this model (at a very basic level) can have Facts (root nodes) and
Dimensions (child nodes). Facts are unique and not related to each other but
any one dimension can be related (ie: belong to) to any Fact.
What I'm trying to do is to create a starschema diagram on-the-fly in my app
and one thing I wondered about was using the Visio API to create our diagram,
possibly from XML or a schema (erx file?) we'd create in our app.
Having read a few posts and the odd Visio blog or two blog I'm thinking this
may be able to be done but am not sure how I'd go about it. I guess I'd need
to d/load the VS2003 SDK and add a reference to the Visio DLL into my app -
but afetr that I'm pretty lost as to where to start or even if this is in
fact possible.
Presently we're evaluating 3rd party Diagramming products (such as Nevron
and FlowChart.Net) but since we were planning to (eventually) export our
schemas into Visio format anyway we thought it would be really good to have
Visio create our diagrams automatically within our app.
Any ideas/commenst would be appreciated - I'm looking for ideas, pointers or
existing articles, examples on how to do this.
TIA...
Mike
I'm working on a .Net 2 WinForms app which allows our B.I consultants to
design starschemas (for our clients) which represent a data-warehouse cube.
As such this model (at a very basic level) can have Facts (root nodes) and
Dimensions (child nodes). Facts are unique and not related to each other but
any one dimension can be related (ie: belong to) to any Fact.
What I'm trying to do is to create a starschema diagram on-the-fly in my app
and one thing I wondered about was using the Visio API to create our diagram,
possibly from XML or a schema (erx file?) we'd create in our app.
Having read a few posts and the odd Visio blog or two blog I'm thinking this
may be able to be done but am not sure how I'd go about it. I guess I'd need
to d/load the VS2003 SDK and add a reference to the Visio DLL into my app -
but afetr that I'm pretty lost as to where to start or even if this is in
fact possible.
Presently we're evaluating 3rd party Diagramming products (such as Nevron
and FlowChart.Net) but since we were planning to (eventually) export our
schemas into Visio format anyway we thought it would be really good to have
Visio create our diagrams automatically within our app.
Any ideas/commenst would be appreciated - I'm looking for ideas, pointers or
existing articles, examples on how to do this.
TIA...
Mike