Can any help with CUBESET function?
I am learning CUBE functions. The only one I can't get to perform is CUBESET.
Here's my scenario: I've constructed an offline OLAP Cube using Access Northwind (as explained in http://wang.se/en/CreateOLAPCube.html). Columns I am using are CompanyName, Country, Quantity, Subtotal, OrderDate, ProductName, CategoryName. My OLAP Cube Dimensions a Customer -- Country -- CompanyName Product -- CategoryName -- ProductName OrderDate -- Year -- Quarter -- Month -- Week -- Date Next I've read articles in MSDN Blogs on CUBE Functions and followed the examples in CUBE Functions 2: A Few Examples. The CUBEMEMBER functions and the CUBEVALUE functions perform fine. But I have yet to be able to construct anything using CUBESET to create a set of All Products Sold. Anybody out there who can guide me to the winning combination of terms in the SET_EXPRESSION that I need to have a working CUBESET? I'll be eternally grateful to anyone who can deciper this. |
All times are GMT +1. The time now is 07:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com