CUBEVALUE Function - Excel 2007

Kresimir Zoric · 06-29-2006, 01:15 PM

Is there a way to send value of other cell as a parametar for CubeValue
Function?

Example from help:

=CUBEVALUE ("Adventure Works","[Measures].[Gross
Profit]","[Product].[Category].[Bikes]","[Date].[Fiscal Year].[FY 2004]")

I would like to use

=CUBEVALUE ("Adventure Works","[Measures].[Gross
Profit]","[Product].[Category].[Bikes]","[Date].[Fiscal Year].[$B2]")

Where $B2 is cell with plain text value "FY 2004".

I think that problem is in "", but when i put CUBEVALUE parametar without
quotations, function doesn't work.

Thank you,

**MKuehner** · 03-15-2013, 11:41 AM

Specific cell refernces must be enclosed in "&&". Try:

=CUBEVALUE ("Adventure Works","[Measures].[Gross
Profit]","[Product].[Category].[Bikes]","[Date].[Fiscal Year].["&$B2&"]")

**HaHoBe** · 03-15-2013, 11:50 AM

Hi, MKuehner,

an answer to a thread which is more than 6 sears old - maybe you have a look at the date the thread was created and the last answer was given. And as the TO is listed as a guest I doubt he will still be waiting for an answer to this thread.

Ciao,
Holger