cubemember function

Hi everyone We have to read data from Excelfiles to our datawarehouse, and we are using a slicer in Excel to select next file to read to our datawarehouse. Our Slicer is created from a Power pivottable that is connected to our datawarehouse. I have created a macro (Macro3) that is recorded and...

Hi all I have a challenge in excel that I cant seem to solve. I built i fairly straight forward financial reporting model using power pivot. Some data are fetched from Dynamics NAV, some from within excel. All data is returned to the data model using queries. I have set up a report in excel...

Hi, I have a table that has, among other information, three that I use most: OC nº Suplier Value 1111 abc 20,00 1112 def 40,00 1113 ghi 60,00 With powerpivot...

Hello, I am entering the world of cube formulas and I am running into a problem that I haven’t seen a solution to. I have a dataset that has 20 names in it that can be further split into 3 groups: A,B,and C. My problem is displaying the names in a single row that belong to one of groups. For...

Hi, I would like to include cell references into the CubeMember function. When I use the “Convert to formulas” function in a pivot table linked via Analysis Services I get a CubeMember function like: CUBEMEMBER("globl0720 KPI DW KPI";{"[KPI].[KPI].[KPI].&[64]"\"[Location].[Blade...