Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |