Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS Tabular- possible to display just detail level data in Excel? Expand / Collapse
Author
Message
Posted Wednesday, September 3, 2014 8:52 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:59 AM
Points: 284, Visits: 1,133
Imagine an HR model and one requirement is to just list all the employee "dimension" data:

Group by Department
Under department one row for each employee with the following columns: Employee Name, BirthDate, HomePhone, Address1, Address2, City, State, Zip

If you try and do that in an SSAS Tabular model via Excel you just get a new "group row" under the employee for each of those.
Do NOT want:

Accounting
----John Smith
---------1975-01-15
--------------1711 Smith Street
------------------FakeCity
---------------------IA
-------------------------50702
(hyphens just for spacing on line, not actually in report)



Instead I would want to just see

Accounting
----John Smith 1975-01-15 1711 Smith Street FakeCity, IA, 50702
----Jane Smith 1979-05-25 1711 Smith Street Fake City, IA, 50702
----Bill Johnson 1965-07-01 25825 3rd Ave Somewhere, MO, 64070

etc...

Is there some straight forward option for that?

It isn't immediately apparent to me.

Thanks!
Post #1610085
Posted Wednesday, September 3, 2014 9:51 PM This worked for the OP Answer marked as solution
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:00 AM
Points: 2,993, Visits: 2,590
You could try changing the "Display" option for the pivot table to "Classic PivotTable layout" (right click in the pivot table, select "PivotTable Options" and select the "Display" tab). Not sure whether it will give you exactly what you are after but it should get a lot closer.


Post #1610345
Posted Thursday, September 4, 2014 6:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 10:59 AM
Points: 284, Visits: 1,133
Thank you, that helped immensely.

I didn't even realize those options existed (never saw them in any of the training materials, blogs, documentation I have reviewed).

Good news is that those options tipped me off to other formatting opportunities.

(Also, I really liked how you could drag / drop right inside the classic layout, seems more intuitive than having to use the fields pane on the far right hand side of the screen).

Thanks!


Now:
Is there ANYWAY to pull together different tables of data with OUT placing a metric (or I guess Microsoft calls them measures) on the pivot table?

Post #1610483
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse