Results 1 to 3 of 3

Thread: Cubevalue function referring cubemember cells and plain memeber name in a cell

  1. #1
    Neophyte antti85's Avatar
    Join Date
    Aug 2019
    Posts
    2
    Articles
    0
    Excel Version
    O365

    Cubevalue function referring cubemember cells and plain memeber name in a cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I'am using cubevalue function by slicing data cells which is utilized by writing cubemember function and this will works as should. I can also slicing data without using cubemember in the attributes what I'am slicing. I have noticed that previous scenarios some attributes doesn't bring the data by using cubevalue function and some will. I'am using these slicers in finance cube and against our organization dimension. Our organization dimension might have same levels name. So can I typing members name without using cubemember function when names are unique in the dimension?

    Hope this explanation is a clear.

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,632
    Articles
    0
    Excel Version
    O365
    Not really.

    Could you post an example workbook and some cube functions to clarify your meaning. I appreciate you might not be able to post your finance cube, but maybe you could mock-up an Excel table and load that into PowerPivot, maybe we can work from that.

  3. #3
    Neophyte antti85's Avatar
    Join Date
    Aug 2019
    Posts
    2
    Articles
    0
    Excel Version
    O365
    Will this help?

    Click image for larger version. 

Name:	Capture.PNG 
Views:	26 
Size:	33.8 KB 
ID:	9318

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •