Forum Replies Created
-
AuthorPosts
-
here is an image of the data model diagram view. There is around 5Million order header records and over 50Million Order Item detail records
Attachments:
You must be logged in to view attached files.I’m using Excel 2016
Thanks – that worked perfect.
I thought I could easily modify this for the second part of my project – sales for days 91 thru 180. How would I create a second measure called [Sales Days 91 thru 180)
March 9, 2016 at 11:40 am in reply to: Printing a list of Measures (or calculated fields) with Formulas #3651<span style=”color: #333333; font-family: ‘Georgia’,serif;”>Wow!!! The Power Pivot Utilities Add-In is unbelievable! I’m not sure why this Add-in is not document in all the books. Thank you for sharing this.</span>
<span style=”color: #333333; font-family: ‘Georgia’,serif;”>I have used the Memory Usage macro in the past after reading about it in some other postings. It is great that it is now just a menu item with the Power Pivot Utilities. I also extend the Table and Pivot Table to include the percent used for each row item (the Memory Size divide by the sum of the Memory Size column). This allows me to quickly see what percent each table and column is using. It would be nice if the macro could do include this… but I have no problem if manually adding it.</span>
September 9, 2015 at 6:58 pm in reply to: Setting up SharePoint for the PowerPivot Data Models #1716Tom – when I used “standard” Excel, I was forced to use the “pre-aggregate” data – it was the only way to get the data set below the 1million row limitation. It’s wonderful how you can extract 10’s of million on rows and having several “tables” joined together in the data model with Power Pivot.
September 8, 2015 at 5:06 pm in reply to: Setting up SharePoint for the PowerPivot Data Models #1697100% of the data is being extracted directly from our SQL database into the PowerPivot data model.
September 8, 2015 at 9:58 am in reply to: Setting up SharePoint for the PowerPivot Data Models #1694Based on some of the information that I have reviewed, it appears that data models stored on SharePoint can be accessed as a data source… that sounds very encouraging. If that is the case, can one spreadsheet access more than one data model? If so, then yes, I could split the one large data model into 2 or 3 smaller models – which would be my preference.
September 4, 2015 at 1:40 pm in reply to: Setting up SharePoint for the PowerPivot Data Models #1675Thanks – I have the books you mentioned in my library so I’ll review the pages you noted.
I’m curious, the “Great PowerPivotPro FAQ” article comments about SharePoint 2010 and it has a limit file size of 2048MB. do you know if this has increased with SharePoint 2013? The data model I created is 2851MB.
Thank you – from your response I was able to perform the calculations I needed. I’ve been working with Power Pivot for couple months and it is awesome!
The only feature I miss with Power Pivot is the ability to have parameters when doing the data extract from our SQL server. In the past I would have the users enter a value in a cell (or cells), and then use them as parameters in the SQL statement to minimize the amount of data being extracted.
-
AuthorPosts