Calculation bind to a hierarchy

Calculation bind to a hierarchy.
I have a report that shows values bind to a geograpich hierarchy dimension:
[Cube Dim Geographic].[Location].[Country
Description].&[Sverige].&[Norr].&[1. Insjön]
I want to set the only SalesChannelId from a parameter and not the whole
hierarchy. Is it possible to use a single geographic parameter,
SalesChannelId, from same dimension to set the selection?
[Cube Dim Geographic].[Sales Channel Id].&[1]
My hierarchy:
Sweden
North Region
Store number one (saleschannelid=1)
Store number two (saleschannelid=2)
Norway...
Thanks in advance!Hello Grundh,
Could you please let me know whether you want to use the parameter to
filter the dimension which the saleschannelid is the parameter value?
If so, you may use the Filter function in the MDX query.
http://msdn2.microsoft.com/en-us/library/ms146037.aspx
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Lu!
I have this strucure in Geograpic Dimension:
Geograpic Dimension:
+ Country Description
+ Country Id
+ Region Description
+ Region Id
+ Sales Channel Description
+ Sales Channel Id (I want to use this ID)
- Location Hierarchy
+ . Country Description
+ .. Region Description
+ ... Sales Channel Description
When i design the report i have to use the "Location hierarchy" to get the
right measures. But i want to use Sales Channel ID as a paramter to the
report.
"Wei Lu [MSFT]" wrote:
> Hello Grundh,
> Could you please let me know whether you want to use the parameter to
> filter the dimension which the saleschannelid is the parameter value?
> If so, you may use the Filter function in the MDX query.
> http://msdn2.microsoft.com/en-us/library/ms146037.aspx
> Hope this helps.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Grundth,
Does the Sales Channel ID an attribute of the Dimension?
If you put the attribute in the filter row, what did you get?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Wei!
Sales Channel ID is an attribute of the dimesion.
Could you please show me how to add a filter to the parameter dataset, and
how that filter could be an parameter to the report?
MDX For Geography dataset:
==================WITH MEMBER [Measures].[ParameterCaption]
AS '[Cube Dim Geographic].[Location].CURRENTMEMBER.MEMBER_CAPTION'
MEMBER [Measures].[ParameterValue]
AS '[Cube Dim Geographic].[Location].CURRENTMEMBER.UNIQUENAME'
MEMBER [Measures].[ParameterLevel]
AS '[Cube Dim Geographic].[Location].CURRENTMEMBER.LEVEL.ORDINAL'
SELECT {
[Measures].[ParameterCaption],
[Measures].[ParameterValue],
[Measures].[ParameterLevel]}
ON COLUMNS ,
[Cube Dim Geographic].[Location].Members
ON ROWS
FROM [CORES]
This is the MDX for the Sales Channel ID Attribute:
================================[Cube Dim Geographic].[Sales Channel Id]
Thanks!
Mats-Erik
"Wei Lu [MSFT]" wrote:
> Hello Grundth,
> Does the Sales Channel ID an attribute of the Dimension?
> If you put the attribute in the filter row, what did you get?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Grunth,
You could use the @.ParamName in the MDX to specify the Parameter and report
designer will recoginize the parameter and you will find it in the Report
Parameters.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Lu!
Can you show me how to add the required filter to my mdx-query that i sent
in my previous post?
Thanks in advance!
"Wei Lu [MSFT]" wrote:
> Hello Grunth,
> You could use the @.ParamName in the MDX to specify the Parameter and report
> designer will recoginize the parameter and you will find it in the Report
> Parameters.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Grunth,
You may use the Filter function in the WITH clause.
Please refer this article:
Filter (MDX)
http://msdn2.microsoft.com/en-us/library/ms146037.aspx
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
You could assist me applying the filter to my mdx-query:
WITH MEMBER [Measures].[ParameterCaption]
AS '[Cube Dim Geographic].[Location].CURRENTMEMBER.MEMBER_CAPTION'
MEMBER [Measures].[ParameterValue]
AS '[Cube Dim Geographic].[Location].CURRENTMEMBER.UNIQUENAME'
MEMBER [Measures].[ParameterLevel]
AS '[Cube Dim Geographic].[Location].CURRENTMEMBER.LEVEL.ORDINAL'
SELECT {
[Measures].[ParameterCaption],
[Measures].[ParameterValue],
[Measures].[ParameterLevel]}
ON COLUMNS ,
[Cube Dim Geographic].[Location].Members
ON ROWS
FROM [CORES]
This is the MDX for the Sales Channel ID Attribute:
================================[Cube Dim Geographic].[Sales Channel Id]
SalesChannel id is a numeric value.
Thanks!
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello,
How about using this:
WITH MEMBER [Measures].[ParameterCaption]
AS '[Cube Dim Geographic].[Location].CURRENTMEMBER.MEMBER_CAPTION'
MEMBER [Measures].[ParameterValue]
AS '[Cube Dim Geographic].[Location].CURRENTMEMBER.UNIQUENAME'
MEMBER [Measures].[ParameterLevel]
AS '[Cube Dim Geographic].[Location].CURRENTMEMBER.LEVEL.ORDINAL'
SELECT {
[Measures].[ParameterCaption],
[Measures].[ParameterValue],
[Measures].[ParameterLevel]}
ON COLUMNS ,
[Cube Dim Geographic].[Location].Members
ON ROWS
FROM [CORES]
WHERE [Cube Dim Geographic].[Sales Channel Id] .&[1]
If in the reporting services, please use
WITH MEMBER [Measures].[ParameterCaption]
AS '[Cube Dim Geographic].[Location].CURRENTMEMBER.MEMBER_CAPTION'
MEMBER [Measures].[ParameterValue]
AS '[Cube Dim Geographic].[Location].CURRENTMEMBER.UNIQUENAME'
MEMBER [Measures].[ParameterLevel]
AS '[Cube Dim Geographic].[Location].CURRENTMEMBER.LEVEL.ORDINAL'
SELECT {
[Measures].[ParameterCaption],
[Measures].[ParameterValue],
[Measures].[ParameterLevel]}
ON COLUMNS ,
[Cube Dim Geographic].[Location].Members
ON ROWS
FROM [CORES]
WHERE @.Parameter
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Lu,
The question returns this:
ParameterCaption ParameterrValue
ParameterLevel
All All [Cube Dim Geographic].[Location].[All] 0
Sweden Sweden [Cube Dim Geographic].[Location].[Count... 1
North North [Cube Dim Geographic].[Location].[Count... 2
SalesChannel1 SalesChannel1 [Cube Dim Geographic].[Location].[Count... 3
but i only want this:
ParameterCaption ParameterrValue
ParameterLevel
SalesChannel1 SalesChannel1 [Cube Dim Geographic].[Location].[Count... 3
Is this possible?
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello,
I would like to perform some research. I appreciate your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.