cube functions

Hi all, I have an Excel file with an underlying pretty complicated PowerQuery query. On the Excel sheet, I have a table from a query, which displays only the needed information, without any redundancy (meaning, that you cannot calculate one column from another). I want to have a button, which...

This formula works in my spreadsheet: =CUBERANKEDMEMBER("ThisWorkbookDataModel",CUBESET("ThisWorkbookDataModel","{([KPCalendar].[CalendarYear].&["&YEAR($C$247)&"],[KPCalendar].[CalendarMonth].&["&MONTH($C$247)&"], [FinancialSummary].[Location].&["&$A$247&"],-{[FinancialSummary].[Referring...

Hi, below i have a formula. I need to make the date and time relative. I have a slicer that pulls in today's date. And I have a cell that has 10 (am). But I cant seem to separate the formula. I would like to point to Slicer_TODAY and cell b22 10. But I'm having trouble...

Hi I'm trying to write a cube function that has just todays sales. Currently i have a slicer for month and year. =CUBEVALUE("ThisWorkbookDataModel","[Measures].[SALES TOTAL NET RETAIL]",Slicer_MONTH1,U$6,Slicer_YEAR1) But I would like to have just today. IE TODAY() I've tried this but that...

Hi, I have a PowerPivot workbook stored on a shared location. I am updating this workbook, once every night, through task scheduler which runs a vb scipt to run a macro in the workbook. The macro is simply ActiveWorkbook.Model.Refresh. Everything works just fine, charts, pivottables etc are...

Hi, Hoping someone can help me figure out right approach here. Summary: Using Excel 2013 connected to a SSAS cube as data source, and cube functions with slicers to create a dashboard. Have following time dimension slicers; Fiscal Year, Fiscal Quarter, Fiscal Month, Fiscal Week & Date, that...