Tuesday, February 07, 2012
Sign-up
Home

Videos

Forums

About
       Contact Us
       Meet the Instructors
You are @ Forums
 
 Ads
  

 
 Learn Microsoft BI Forum
 
  Learn Microsoft BI Forum  Core Servers  Analysis Servic...  CUBEMEMBER Function
Previous Previous
 
Next Next
New Post 6/30/2009 10:31 PM
  Qazafi
51 posts
6th Level Poster


CUBEMEMBER Function  

Hi All

 

I am referencing Excel cell in CUBEMEMBER Function in Excel 2007 For example my Formula is
=CUBEMEMBER("My Job Connection",CONCATENATE("[Dimension COST CENTRE].[Cost Centre Description].&[",E1,"]"))
Where E1 is Excel cell I m referencing and it is working perfectly. But as soon as I have Two dimension in my CUBEMEMBER function I could not figure out how can I refer the excel cell inside my CUBEMEMBER function. For example my Formula is
 
=CUBEMEMBER("My Job Connection ",{"[Dimension COST CENTRE].[Cost Centre Description].&[010101]","[Dimension POST CODE].[Post Code].&[4001]"})
In the above CUBEMEMBER Function I would like to replace [010101] value with a reference Excel cell as I have done in the first example (E1)
 
Any body has any idea how could I refer excel cell inside this CUBEMEMBER function in two dimension.
 
I will really appreciate your help
 
Many thanks
 
Qazafi

 

 
 
New Post 7/2/2009 6:48 PM
  Qazafi
51 posts
6th Level Poster


Re: CUBEMEMBER Function  

Hi All

I have found the answer to my question.

Many thanks

 
 
New Post 6/7/2010 11:38 PM
  sl0140
2 posts
No Ranking


Re: CUBEMEMBER Function  

hi Qazafi,

 

I have the same issue.  I havea  cubemember statement with 2 criteria, and i am trying to reference the month/year from cells in both criteria but it returns an error. Would you mind sharing how you did yours??

 

Example:

=CUBEMEMBER("Connection1",{"[Date].[Year].&[2010]","[Date].[Period].&[2010]&[5]","[Time Calculations].[YTD Pr Yr]"},"Budget Amount")

 

I want to replace 2010 with B2 and 5 with A2......  in both criteria..

 

any help would be appriciated

 

Thanks

Scotty

 
 
New Post 6/7/2010 11:38 PM
  sl0140
2 posts
No Ranking


Re: CUBEMEMBER Function  

hi Qazafi,

 

I have the same issue.  I havea  cubemember statement with 2 criteria, and i am trying to reference the month/year from cells in both criteria but it returns an error. Would you mind sharing how you did yours??

 

Example:

=CUBEMEMBER("Connection1",{"[Date].[Year].&[2010]","[Date].[Period].&[2010]&[5]","[Time Calculations].[YTD Pr Yr]"},"Budget Amount")

 

I want to replace 2010 with B2 and 5 with A2......  in both criteria..

 

any help would be appriciated

 

Thanks

Scotty

 
 
New Post 6/14/2010 3:12 PM
  Qazafi
51 posts
6th Level Poster


Re: CUBEMEMBER Function  

here is what it should look like (or something similar if I mess up a quote):

=CUBEMEMBER("My Job Connection ", CONCATENATE("([Dimension COST CENTRE].[Cost Centre Description].&[",E1,"],[Dimension POST CODE].[Post Code].&[4001])"))
Please translate to the question
 
 Page 1 of 1
Previous Previous
 
Next Next
  Learn Microsoft BI Forum  Core Servers  Analysis Servic...  CUBEMEMBER Function
  
Copyright 2011 by CIOBriefings LLC