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

Row Header are not display Expand / Collapse
Author
Message
Posted Thursday, July 11, 2013 4:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 6:24 AM
Points: 7, Visits: 60
Hello,

I write a MDX like this

WITH
MEMBER [CPM] AS [Measures].[Net Budget]/[Measures].[grp1]

SELECT
NONEMPTY( {[MASTER Country 1].[Country Name].Members
* [MASTER Company].[Company Name].Members
* [MASTER Brand].[Brand Name].[Brand Name].Members
}) ON rows,
{ [Measures].[Net Budget],[CPM]} on COLUMNS
FROM
[CubeTelecident2]

where ([MASTER Unit Period 1].[Id Unit Period].&[1300]
, [MASTER Country 1].[Id Country].&[427]
,[MASTER Company].[Id Company].&[1813] )

But Result not showing header text of Rows members. (As per attachment)



  Post Attachments 
Untitled.jpg (9 views, 30.53 KB)
Post #1472496
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse