Welcome Guest Search | Active Topics | Log In | Register

Update to use in PowerPivot created PivotTables? Options
Previous Topic · Next Topic
Colin
#1 Posted : Sunday, January 24, 2010 11:01:17 AM
Rank: Newbie

Groups: Registered

Joined: 1/24/2010
Posts: 3
Hi, I was wondering if an update would be available to work with PowerPivot PivotTables. It appears that the only thing that doesn't work is loading metadata, so the metadata tab in the editor is empty.
Back to top
 Report Abusive | Report SPAM
Admin
#2 Posted : Monday, January 25, 2010 2:06:20 PM
Rank: Administration

Groups: Administrators

Joined: 5/23/2009
Posts: 13
Hello - Yes, it is part of my plans. However, calculated members do not show up in the Gemini (PowerPivot) task pane - they show up only in the traditional PivotTable Field List. But, I will work to get the metadata part working in the next 2 months.

Tyler
The Admin
Back to top
 Report Abusive | Report SPAM
Colin
#3 Posted : Tuesday, January 26, 2010 6:30:30 PM
Rank: Newbie

Groups: Registered

Joined: 1/24/2010
Posts: 3
Thanks for the response. I actually created a calculated member on a PowerPivot dimension using VBA. The MDX shows that the calculated member is included in the query, but I don't see this member in the PivotTable or anywhere else.
Back to top
 Report Abusive | Report SPAM
Admin
#4 Posted : Wednesday, January 27, 2010 9:06:17 PM
Rank: Administration

Groups: Administrators

Joined: 5/23/2009
Posts: 13
Yes, you won't see it in the Gemini Task Pane. You'd need to explicitly go the the PivotTable Tools - and show the PivotTable Field list. Right now, however, PowerPivot doesn't like when you switch between the Gemini Task Pane and the PivotTable Field List (you need to choose one or the other).

With that said, if you created a calculated member (rather than a calculated measure) it might not show up in the Excel PivotTable Field list either. You can see a discussion of (the weak support for calculated measures) in another thread (and it doesn't look like Excel 2010 makes calculated member support any better).
The Admin
Back to top
 Report Abusive | Report SPAM
Colin
#5 Posted : Wednesday, January 27, 2010 10:22:25 PM
Rank: Newbie

Groups: Registered

Joined: 1/24/2010
Posts: 3
Oh, I was referring to calculated members (which isn't showing up in either task pane). PowerPivot is designed to use DAX for calculated measures. I suspect that MDX based calculated measures don't show up in the PowerPivot task pane purposely be design. On the other hand, the MDX expression allows the calculated measure to show up in the PivotTable OLAP task pane. So long as both DAX and MDX calculated measures show up in the PivotTable task pane after connecting to the model saved in SharePoint, I don't see an issue with the current behavior.
Back to top
 Report Abusive | Report SPAM
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

YAFPro Theme Created by Jaben Cargman (Tiny Gecko)
Powered by YAF 1.9.3 | YAF © 2003-2009, Yet Another Forum.NET
This page was generated in 0.181 seconds.