May 20, 2015 at 8:29 am
Hi all,
I have a few queries regarding using a SSAS Tabular model in an Excel pivot table. Now, I know these things are possible, but I don't know if limitations of Excel stop it from happening.
- Reporting Properties - I know in Multidimensional you could set Reporting Properties so that when you hover over a dimension in a pivot table, you can see a tooltip with extra dimension data. When I right click a dimension in rows, I see 'Show Properties in Report', but it says 'No Properties Defined'. This is obvious because I don't know where I can define them in Tabular!
- Column Descriptions - In the Tabular designer, I'm able to add Descriptions to all columns, and I'm expecting in a pivot table to be able to see this description when I hover over the field. This isn't happening. It does however, work in Power View!
- Sorting fields in data source order - Is there any way to order the field list in a pivot table by data source order when connected to a Tabular model?
- Managed Sets - Is there any way to create a Data set in the Tabular model instead of within Excel?
Any help in this is much appreciated!!
May 21, 2015 at 2:24 am
Anyone? Please help 🙂
May 21, 2015 at 7:11 am
mm7861 (5/20/2015)
Hi all,- Reporting Properties - I know in Multidimensional you could set Reporting Properties so that when you hover over a dimension in a pivot table, you can see a tooltip with extra dimension data. When I right click a dimension in rows, I see 'Show Properties in Report', but it says 'No Properties Defined'. This is obvious because I don't know where I can define them in Tabular!
- Column Descriptions - In the Tabular designer, I'm able to add Descriptions to all columns, and I'm expecting in a pivot table to be able to see this description when I hover over the field. This isn't happening. It does however, work in Power View!
As far as I know this Tooltip feature is not available in Tabular. May be in future releases they may correct this.
Thank You
May 21, 2015 at 7:53 am
I thought as much. Seems as though they've given this power to Power View! 🙁
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply