All Questions
Tagged with powerpivot cube
19 questions
1
vote
1
answer
1k
views
Retrieving data from DataModel (Power Pivot) within VBA
first of all, apologies. I am a relatively new VBA user, and I am a bit lost in the search for the answer to the question below.
I am creating a UserForm which will include some ComboBox to get user's ...
- 13
0
votes
1
answer
364
views
DAX TOPN Ascending Returns Blank Values
In Power Pivot, I have the following DAX Measure which works great including being connected to a slicer using CUBEVALUE.
Meas_TopPerformerWeighted:=VAR TopAgentName =
CALCULATE (
...
0
votes
1
answer
451
views
Combine Two or more named ranges (with formulas) to one named range (array)
I am trying to use formula.1 to get data from the Data model and I have managed to use O7:P7 as an array in the Cubermember function.
like this:
This is sample data.
=CUBEVALUE("...
1
vote
0
answers
133
views
Excel cubevalue error #N/A FieldName with period
I have written the following expression with cubevalue
=CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of Indicator Value]","[economics].[Ticker].&["&($B$21)&"]","[economics].[...
- 13
3
votes
1
answer
389
views
Show only facts in Excel's show fields dropdown when using tabular cube
When having a connection to a multidimensional cube in Excel (powerpivot table) there is an option to Show fields and select only one fact and its related dimensions.
Here is what I mean
This shows ...
- 991
0
votes
0
answers
163
views
MDX Function (Excel PowerPivot) to Exclude Non Numeric Values from DB
I am quite new to MDX and I am trying hard to write a query that allows me to retrieve only numeric values.
My query at present is:
SELECT NON EMPTY {ISNUMERIC([Measures].[Average Booking Window])} ...
- 135
3
votes
1
answer
1k
views
How to filter out multiple dimensions in Excel using cube functions?
I've read this post (use Cube Functions to get filtered dimensions) and it's quite helpful, but I want to add one more level of filtering.
So let's say my data looks like this in PowerPivot:
Month ...
- 440
0
votes
0
answers
148
views
DAX IF ELSE statement performance issue
Sales := CALCULATE(
IF(HASONEVALUE('SalesTable'[Sales]),CALCULATE(VALUES('SalesTable'[Sales]))),
LASTNONBLANK('SalesTable'[Date],1))
The above query work fine. When I filter by month, it will shows ...
- 311
1
vote
1
answer
237
views
SSAS Cube : How to expand a particular level of dimension from pivot table
How can I expand a particular level of dimension from a pivot table. Currently when I select a particular dimension, all other dimensions on the same level also expand which causes long processing ...
- 811
0
votes
1
answer
102
views
SSAS Cube Modelling Fact or Dimension - No Additive Columns
Im pretty new to BI modelling and have been assigned a project to create a BI solution for a Patient Administration System (millions of rows). There are no sales or additive information in the system....
- 399
0
votes
1
answer
2k
views
Unable to refresh powerpivot data in sharepoint
I have a SSAS cube and I would like to create some reports using excel out of the data. Since creating a report directly from the cube involved some performance issues, I loaded the data from the cube ...
1
vote
1
answer
527
views
When I convert a pivot table to formulas I get #GETTING_DATA instead of values
When I convert a pivot table to formulas I get #GETTING_DATA instead of values in the valuecells of the former pivot table.
The row labels and column labels are showing fine. But all the value cells ...
- 21.6k
4
votes
1
answer
356
views
SSAS Tabular / PowerPivot Date Filters
I am trying to design a SSAS 2014 Tabular Cube that has easy to use custom date filters. For example, I want users (in excel for example) to be able to select a custom date range such as "This Month",...
- 93
0
votes
1
answer
32
views
I'm connecting a PowerPivot query to a MS Analysis server cube. double record
I'm connecting a PowerPivot query to a MS Analysis Server Cube. The query result i get contains double records for a single dimension (personnelnr). This because of a name change during a day in the ...
- 1
0
votes
1
answer
130
views
Efficiently store and retrieve price points over time ranges
We are loading data from a source that contains rates with date ranges. The rate seldom changes. E.g.
ProductId, SupplierId, CategoryId, Rate, ValidFrom, ValidTo
1, 2, 3, 4.0, 2014-01-01, 2014-06-30
...
- 1,208
2
votes
1
answer
6k
views
Cell References in Cube Formula - Excel PowerPivot
I'm looking to run a CUBEVALUE formula with member expressions based on the contents of multiple different cells. For this example i have 2 cells with a value for REGION in:
I15: Border
I16: Midlands
...
- 21
2
votes
2
answers
2k
views
Filter Dimension values
I have a master Customer dimension (that I don't maintain). My fact table includes customer info. When I compile the cube, everything looks good, by browsing the cube I see my fact rows with only ...
- 342
1
vote
1
answer
2k
views
use Cube Functions to get filtered dimensions
How do you get a list of filtered dimentions from a cube function
say I had a dimention table of addresses:
1234 Any Street Detroit MI 48229
55588 187th St E Seattle WA 98888
4 Blossum Ave ...
- 4,037
5
votes
0
answers
1k
views
Any sample on how to expose a olap cube as oData so it can be used using powerpivot?
I'm looking for a sample on how to expose an olap cube as an odata feed so it can be consumed by powerpivot. I do not want to provide direct access to the cube.
- 118