Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

trying to make my first report and it is not going :( Expand / Collapse
Author
Message
Posted Tuesday, March 19, 2013 4:53 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 24, 2016 5:43 AM
Points: 552, Visits: 965
This works on the adventure works cube.
Post your query

WITH Member [Measures].[Something Made Up] as
(
[Measures].[Internet Order Count]
)

Select
{
[Measures].[Internet Order Count]
,[Measures].[Something Made Up]
}
On Columns,
(
[Sales Territory].[Sales Territory Country].&[Canada]
)
on rows
FROM [Adventure Works]

Post #1432940
Posted Thursday, March 21, 2013 12:41 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 9:34 AM
Points: 97, Visits: 166
i will try it. thanks a bunch
Post #1433602
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse