Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Creating local cube slices.
I upgraded to SQL 2000 and tried to gain a better understanding of the CREATECUBE and INSERT INTO statements which are used in conjunction with the SELECT...FROM...WHERE clause. I'm not sure which it was but I am no longer experiencing the problem. -
To "Excel" or not to "Excel"?
One issue that I ran into using Excel's OLAP is that you have few options when creating aggregations on columns. For example, you cannot create an average or a percent of a column using the wizard. This can cause column total information to be useless if you use certain formulas in the source... -
How to start building a cube in SQL server?
The OLAP Manager Tutorial that is installed with OLAP gives a fairly good overview of the physical cube creation process. If you are looking for more detail on design, take a look at 'Microsoft OLAP Unleashed' ISBN 0-672-31671-4. -
Creating local cube slices.
Thanks for the info, but would it be an empty row in a dimension table or an empty row in the fact table? I've checked the source data and all dimension tables are populated correctly, but, when I use the MDX sample application installed with OLAP and I query for the same data, there are blank... -
Creating local cube slices.
I'm relatively new to OLAP data sources. Has anyone attempted to create local cube slices from an OLAP source through Visual Basic using SQL queries instead of MDX queries? I have the Visual Basic structure set up and am able to create a full local cube based on the OLAP server using the...
