Stack Overflow
Stack Overflow

Questions tagged [cubefunctions]

In mathematics, a cubic function is a function of the form f(x)=ax^3+bx^2+cx+d.

In mathematics, a cubic function is a function of the form f(x)=ax^3+bx^2+cx+d, where a is nonzero; or in other words, a function defined by a polynomial of degree three.

5 questions
1
vote
0 answers

How to filter a date range in a cubeset function?

I want to implement a filter in a cubeset function to get the values only for a limited time period, e.g. 2 weeks. However, I struggle with the syntax of the filter function. Getting the values in a cubevalue function works for the selected time…
Süleyman Karapinar
  • 11
  • 2
1
vote
0 answers

Excel 2013 MDX in Cube Function

I'm using excel 2013 and need some assistance with a few CUBE function needs and the proper MDX needed to resolve my issue. I would like to exclude from one MDX set, the names in another to create a "NOT IN" scenario. I have a hierarchy table with a…
DCSlick
  • 19
  • 1
0
votes
0 answers

How do I add a second condition to current exists function in a CubeMember function to return the ID field

Hi I was wondering if there was a way to apply two conditions to an Excel 365 CubeMember function. I currently have an old query that was poorly written and fails when when there are two sub account names that are the same. I would like to add the…
Eagle1
  • 13
  • 4
0
votes
1 answer

Get ORDERED SET with CUBESET function for multiple periods (OLAP)

I have the below CUBESET function that generates SET of LOCATION COUNTRIES (names) ordered by Quantity, which works fine. I would need the same but using multiple months. Each month that I add in the formula below is multiplying the list of members…
Jar
  • 13
  • 4
0
votes
1 answer

CUBEFUNCTIONS - one fails then all fail?

Does anyone have any experience writing CUBE* functions in Excel? I'm writing these functions against an OLAP db and firing MDX strings at the db, via these functions. Seems that in certain circumstances if one of the functions fails and returns…
whytheq
  • 34,466
  • 65
  • 172
  • 267