hi all,
i am new to the field of olap cube. i learnt to make cubes by using tutorial given in sql server. i have made some of the cubes using the sample databases given there. i now want to view the cube, the cubes dimension and all in the manner its structure is maintained that is the visual representation of the structure. i am unable to find any option on sql.
so i tried to export the cube on excel (is this option ok, or should i export to access?).
here it wants me to specify, all the fields of the dimensions selected in the cube, in the pivot table and that too in tables and rows. it is getting all too complex for me. can somebody helpout?
and if access can give me a visual representation of the cube, can anyone tell me how?
thanks in advance to everyone who'll take pains to sort out my problems.
mm
i am new to the field of olap cube. i learnt to make cubes by using tutorial given in sql server. i have made some of the cubes using the sample databases given there. i now want to view the cube, the cubes dimension and all in the manner its structure is maintained that is the visual representation of the structure. i am unable to find any option on sql.
so i tried to export the cube on excel (is this option ok, or should i export to access?).
here it wants me to specify, all the fields of the dimensions selected in the cube, in the pivot table and that too in tables and rows. it is getting all too complex for me. can somebody helpout?
and if access can give me a visual representation of the cube, can anyone tell me how?
thanks in advance to everyone who'll take pains to sort out my problems.
mm