In spite of my bad english, i hope you'll understand my question =)
I've to build an olap data cube which contains 3 data table... But i couldnt find any document about it. I've heard Adodb, Adomd and Mdx concepts but i have no idea about tehem, i ll be grateful if you help me...Hello,
hope I understood you well.
a cube has exaclty 1 fact table. You'll have to join the 3 table into one in a proper way.
If you mean, these three tables still have to become dimensions or facts, and you did not get the concepts of dimensions and facts, search for examples in internet, there are plenty.
Hope this helps
Tobias|||I have a similiar problem which i hope someone can help me with.
What i would like to know is how to create a Cube from a programming perspective (not using the various wizards provided)
For a relational database, i create a connection to the database and then execute SQL commands on it using the SqlCommand object. I can then create a table in the database by having the SqlCommand execute "CREATE TABLE ... etc".
For a muli-dim database, i connect to it using a AdomdConnection object. I can then execute MDX commands on it using an AdomdCommand object.
But the MDX syntax doesn't seem to support the creation of Cubes. I can create a local cube or a session cube, but not a cube from scratch.
Am i missing something?
Is there another way of creating cubes?
No comments:
Post a Comment