If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|