Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

multiple criteria in cubeset function in excel 2013

Posted on 2014-09-02
2
2,663 Views
Last Modified: 2014-09-03
Hi I am looking to return a CUBEVALUE which includes filters on the same dimenstion twice.

The code I am using is as follows but keeps returning #N/A.  Can anyone help with where I have gone wrong in the code??

=CUBEVALUE("athenatest_athena2012 Voids","[Measures].[Stock]","[Void Entity].[Entity Desc].[Stock]","[Wdh Prop Type].[Head Name].[Residential]",CUBESET("athenatest_athena2012 Voids","{[WDH New Areas].[NPT Code].[South East NPT]","[WDH New Areas].[NPT Code].[Wakefield Rural (C) NPT]}"))

Many thanks in advance.
0
Comment
Question by:deborahhowson00
2 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40300362
HI,

On the array you have the " before the { an after the }

pls try

=CUBEVALUE("athenatest_athena2012 Voids","[Measures].[Stock]","[Void Entity].[Entity Desc].[Stock]","[Wdh Prop Type].[Head Name].[Residential]",CUBESET("athenatest_athena2012 Voids",{"[WDH New Areas].[NPT Code].[South East NPT]","[WDH New Areas].[NPT Code].[Wakefield Rural (C) NPT]"}))

Regards
0
 

Author Closing Comment

by:deborahhowson00
ID: 40300586
Super thanks, oh the little things... spent hours on that :(
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question