Cube formulas not working when linking against cells with formulas in them


dear helpers

i have annoying problem , far haven't seen answer (or in fact else asking question) in forums/ posts.

so, before start, using excel 2010 , have powerpivot v1.

i want start using olap cubeformulas derived powerpivot model. basically, want show sales product (products on rows) how sold month (i.e. mtd), quarter date , achieved in full quarter. let assume looking @ february 2015. should show me sales per product did in february month, sold quarter date (january + february) , sold in entire quarter (jan + feb + march).

i using cell picking correct quarter using offset match formula looking @ month have selected in slicer (the slicer in turn connected filter showing month) , running offset match formula against lookup table. in end, correct quarter in cell has exact same spelling in powerpivot database (i have double tripple checked this). , linking cubeformula cell , n/a#.

when converting pivot cubeformulas, cell quarter used in cubeformula same 1 offset match formula is. both read "2015 - q1".

summary: why can't cubeformula use cell input formula spelled same?

can me? doesn't seem 1 can attach file here, have example file of trying explain here.

kind regards

christoffer

cube functions in excel powerful, quite hard work with. there's lot going on behind scenes.

the reason errors shown in cell containing a cube function not result of function, rather caption of lies behind. clear example of cubeset function, results in set of values; function accepts argument containing caption shown in excel.

in short, you're looking not merely cell containing text "2015 - q1", cube reference value "2015 - q1" in model. 1 difference between these cube reference contains information on table , column value found in. news when transform pivot table cube functions, you'll see main argument of function (cubemember, specifically) text containing reference - including value (this mdx expression). it's possible construct text table/column reference , value you're looking for.



SQL Server  >  Power Pivot



Comments

Post a Comment

Popular posts from this blog

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

SQL Server PSProvider SQL Server Authentication

greetings: i'm trying use sql psprovider powershell.  can make work management studio by right-clicking next database object.  however, unnable external powershell session. note: i have tried using suggested method msdn ( initializesqlprovider.ps1 , function sqldrive ) i following error: new-psdrive : sql server powershell provider error: not connect 'emtyb06\default+bca_empresarial'. [object ref erence not set instance of object.] @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -credential $cred -scope 1 new-psdrive : sql server powershell provider error: path sqlserver:\sql\emtyb06\default+bca_empresarial not exist.  please specify valid path. @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -cred...
Read more

Getting error when using Excel Destination

Image
i getting error when using   transferring data oledb source  to excel destination i using dynamic file connection means each time new file generated @ desination folder getting error given above path stored in variable @[user::path] :c/admin/ for creating excel file using expression excelfile path: @[user::path] +(dt_str,4,1252) datepart("yyyy",getdate()) +right("0"+(dt_str,4,1252) datepart("m",getdate()),2) +right("0" + (dt_str,4,1252) datepart("d",getdate()),2)+ right("0" + (dt_str,4,1252) datepart("hh",getdate()),2)+right("0" + (dt_str,4,1252) datepart("mm",getdate()),2)+right("0" + (dt_str,4,1252) datepart("ss",getdate()),2)+".xls" now when clicking on exceldestination component mapping getting error ================================= error @ insertingdatafromexcel de...
Read more