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

Apply Sourcecode in SSAS Expand / Collapse
Author
Message
Posted Tuesday, November 05, 2013 1:19 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 6:47 AM
Points: 56, Visits: 184
Goal:
Use the KPI [Measures].[Profit Margin] inside of SSAS:s tab named Calculation and then use it in my SSRS report and other user

Problem:
I tried applying the source code in "Named set" or "calculated set", in SSAS, but it didin't work at all. I don't know how to apply the source code inside of SSAS.

Information:
*I'm using SQL server 2012
*Today, I have the source code in my SSRS report in the query designer view, inside of dataset, but I want the code to be inside of SSAS that I can allow users to use the same source code in their report.
*The report's data source is SSAS in my SSRS. MDX code only.
*The source code can be used for AdventureWorks.

WITH 
MEMBER
[Measures].[Profit Margin] AS
([Measures].[Internet Sales Amount] - [Measures].[Internet Total Product Cost] ) / [Measures].[Internet Sales Amount] ,
FORMAT_STRING="Percent"
SELECT
{
[Measures].[Internet Sales Amount],
[Measures].[Internet Total Product Cost],
[Measures].[Profit Margin]
}
ON COLUMNS ,
{
[Date].[Calendar].[Calendar Year].&[2007],
[Date].[Calendar].[Calendar Year].&[2008]
}
ON ROWS
FROM [Adventure Works]



  Post Attachments 
bild.png (5 views, 16.33 KB)
Post #1511611
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse