No announcements
Found 919815 threads
-
0 VotesPrefilter dimension for Excel pivot table
Join the dimension with the fact table and mark these dimension members as fact members in the ETL process.Answered | 1 Replies | 1962 Views | Created by OndrasZMoravy - Wednesday, January 22, 2014 10:53 AM | Last reply by Thomas Ivarsson - Wednesday, January 22, 2014 6:03 PM
-
0 Votes
Dimensions and Measures restrictions in excel pivot table
Hi Thiru, PowerPivot for Excel is an Add-In which uses a local version of Analysis Services (SSAS) to process data and make calculation to respond to user queries made ...Answered | 1 Replies | 1912 Views | Created by Thiru R - Saturday, January 26, 2013 4:50 PM | Last reply by silna - Sunday, January 27, 2013 10:58 AM -
0 Votes
Prefilter Dimensions
Surely I don't have to create a DSV of the fact table too do I?Answered | 6 Replies | 699 Views | Created by urbanKoala - Wednesday, November 11, 2015 3:37 PM | Last reply by Amit-Tomar - Friday, November 13, 2015 1:40 AM -
0 Votes
OLAP Pivot Table Extensions Using a dimension in a calculation
after connecting to the cube through excel, right click the pivot area and click "OLAP PivotTable Extensions...Answered | 3 Replies | 5847 Views | Created by BI Newcomer - Monday, July 29, 2013 8:12 AM | Last reply by Butmah - Monday, July 29, 2013 6:52 PM -
0 Votes
How to stop Excel pivot table loading dimension data immediately
I just assumed the behavior in the cube browser, if you drop in dimensions without a measure it loads nothing up would apply in excel.Answered | 7 Replies | 722 Views | Created by JLJ1976 - Friday, June 24, 2016 1:17 PM | Last reply by Alexei Stoyanovsky - Friday, June 24, 2016 10:14 PM -
3 Votes
Power Pivot Table Fields Missing from Excel
"PivotTable" is the tool in Excel to work with data from serveral types of data source, like here "Power Pivot".Answered | 3 Replies | 5073 Views | Created by Tyler Becker - Friday, July 4, 2014 4:22 AM | Last reply by Tyler Becker - Monday, July 7, 2014 5:40 PM -
2 Votes
Excel Pivot Table in BI 2010
Hi WLID1966, I think your issue is more than of creating and configuring an OLAP cube, you have added dimensions and measures to your cube but you do not see them.Answered | 2 Replies | 10061 Views | Created by WLID1966 - Sunday, January 9, 2011 10:55 PM | Last reply by Khurram Jamshed - Monday, January 10, 2011 5:15 AM -
1 Votes
Searching for a Product in Pivot Table
If i search for a Product in excel Pivot Table as you do, it still working as case insensitive.Answered | 3 Replies | 784 Views | Created by Jenny_1234 - Tuesday, April 18, 2017 12:04 PM | Last reply by willson yuan - Thursday, April 20, 2017 5:18 AM -
0 Votes
Pivot Table in Excel Services
For complex authoring and ad-hoc data analysis, the best tool is still the desktop version of Excel.Answered | 2 Replies | 11141 Views | Created by pryank rohilla - Tuesday, April 27, 2010 3:01 PM | Last reply by Anthony Valey - MSFT - Wednesday, April 28, 2010 6:34 PM -
0 Votes
Excel 2007 Pivot table and SSAS Cube
Do you have one sheet with one pivot table ?Answered | 4 Replies | 2055 Views | Created by Pavan133 - Tuesday, October 1, 2013 12:37 AM | Last reply by Elvis Long - Thursday, October 3, 2013 9:33 AM -
0 Votes
Excel pivot connected to Cube
Do you how to add filters to a pivot book?Answered | 6 Replies | 1444 Views | Created by Surendra_Thota - Thursday, October 3, 2013 11:39 AM | Last reply by Surendra_Thota - Tuesday, October 8, 2013 8:02 AM -
0 Votes
controling access to dimensions and measures in pivot table using cube as data source
I want to use the role restrictions to restrict access to one company, so that a user having the role can only see the measure amount from fact table ...Answered | 4 Replies | 4252 Views | Created by rpfinn - Wednesday, November 30, 2011 3:56 PM | Last reply by rpfinn - Friday, December 2, 2011 2:17 PM -
0 Votes
PIvot tables in excel
I want to save this excel generated report to the server and then make the client inport this file as an attachment.Answered | 6 Replies | 4580 Views | Created by akhilesh_daprofessional - Tuesday, April 28, 2009 5:56 AM | Last reply by akhilesh_daprofessional - Monday, May 4, 2009 10:45 AM -
0 Votes
Excel Chart Updating with Pivot table
Hi Grant I have done following steps to resolve the issue, hope it will work for you as well: 1) I have a Pivot Table and Pivot ...Answered | 7 Replies | 18148 Views | Created by GS80 - Tuesday, March 6, 2007 9:29 AM | Last reply by Hussain Ali - Thursday, October 1, 2009 10:23 AM -
2 Votes
Automatically copy Pivot table info into excel table
By the way this is related to Excel in general rather than Power Pivot.Answered | 2 Replies | 1490 Views | Created by SP Assest - Friday, June 20, 2014 10:57 AM | Last reply by Gerhard Brueckl - Tuesday, June 24, 2014 7:51 AM -
0 Votes
Excel table (non-pivot) based on PowerPivot table
Once you do this and read the SSRS data into PowerPivot, you can use a 'flattened' pivot table to render a view more closely aligned to ...Answered | 5 Replies | 9267 Views | Created by roto-tom - Thursday, February 2, 2012 8:44 PM | Last reply by Javier Guillen - Saturday, February 4, 2012 10:41 PM -
0 Votes
Search option on Pivot table generated by excel when connected to SSAS cube
If i search for a Product in excel Pivot Table as you do, it still working as case insensitive.Answered | 5 Replies | 1089 Views | Created by PXPRXR - Monday, April 10, 2017 7:58 AM | Last reply by PXPRXR - Sunday, June 4, 2017 6:17 PM -
4 Votes
Download power pivot table INTO excel
Hi Alex, If you're using Excel 2013 or later, you can try using the Linkback table feature.Answered | 3 Replies | 1501 Views | Created by AlexMartini - Thursday, October 20, 2016 5:36 PM | Last reply by Michael Amadi - Thursday, November 24, 2016 2:17 PM -
2 Votes
Using Slicer to change row dimension in pivot table
Hi, We wrote a detailed post about this exact ...Answered | 2 Replies | 1869 Views | Created by BOBJMAN - Thursday, September 18, 2014 3:36 PM | Last reply by Idan Cohen - Sunday, September 28, 2014 2:37 PM -
0 Votes
SSAS Cube & Pivot table
You can probably build two more dimensions: [Low Limit] and [High Limit].Answered | 3 Replies | 5742 Views | Created by KJ007 - Monday, August 30, 2010 8:32 PM | Last reply by Boyan Penev - Tuesday, August 31, 2010 11:33 PM - Items 1 to 20 of 919815 Next ›
No announcements
