Jae Wilson from @OnyxReporting shares how to build better Cube based Dashboards with native Excel cube functions Read the full blog post here: www.onyxreporti...
Пікірлер: 20
@sonali9497 жыл бұрын
This was legit the most simple and useful video on all the Cube functions. Thank you very much.
@penglai36685 жыл бұрын
It is!
@utoob99997 жыл бұрын
Very helpful and useful demo, Jae - one of the best I've seen thus far. I'll check out your other videos! Thank you!
@kannana34417 жыл бұрын
Excellent topic, nicely sliced , good job mate keep it up. Very useful.
@Saur6 жыл бұрын
This is extremely useful, thank you so much for sharing!
@FRANKWHITE19962 жыл бұрын
Thanks for sharing! 👍
@canefan174 жыл бұрын
If I convert a pivot to cube, and then later refresh my power Query, will it automatically update the cube table like a pivot table would auto update with the new date field/column, etc?
@yifeng7137 Жыл бұрын
this is GOLD ❤
@chrisbroughton66 жыл бұрын
Great video but this seems like a lot of manual work. Power Pivot will pull new through data automatically where as in the cube you have to update your data by hand if you want to make additions and modifications. I guess this is great if you have a "set and forget" style dashboard however i still think powerpivot has some great out of the box functionality that exceeds cube functions
@canefan174 жыл бұрын
I agree, but my customers want the ability to insert columns to their pivot tables at different points in the pivot table (which you obviously can’t do). So converting to cube is helpful for that. My problem is what you mentioned.. when I get new data I’m for the next month and hit refresh all for power Query, I want it to auto populate the new data like a pivot table would. To my knowledge the cube won’t auto update unless you go add in the formulas for the new data. (which might have a new date in the column field list).
@canefan174 жыл бұрын
If my next month of data has a new sales person, will it automatically add them to the cube upon data>refresh.
@Ghostrider-hp3mm6 жыл бұрын
Thank you very much, great Job! One Thing keeps bothering me: how do you rename the "title" of the Connection from "ThisWorkbookDataModel" to "cube" (as in your Video)? Thanks again.
@HarryViral5 жыл бұрын
thank you so much...
@MrAdingle5 жыл бұрын
Thank you
@aneezka3195 жыл бұрын
You did a good job but it could have been made better had you explained the syntax . eg, referring to a cell, use of ampersand etc
@jonnytech_7 жыл бұрын
Can you use cube formulas to look up items instead of values?
@jaewilson077 жыл бұрын
Jonathan yes. The cubemember function returns members of a dimension. You just have to know the dimension key (item number or gl number etc.)
@jonnytech_7 жыл бұрын
Jae Wilson thanks I'll give it a go 🤔
@christoslefkimiotis98892 жыл бұрын
(sales - cos)/sales = margin (sales - cos)/cos = markup 2 different things
@kozlo110 ай бұрын
Where can we download the file u are using in the video? without it, the video is useless. You waste our time and yours