Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shaggy
Posting Yak Master
248 Posts |
 Posted - 2009-09-11 : 06:01:35
|
| Hi all,I want to know about SSAS CUBE reports.what for it is used and can we make normal reports using SSAS CUBE.Iam little bit confused Please advice. |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-09-11 : 06:36:55
|
| HiRefer..http://hmorgenstern.spaces.live.com/Blog/cns!28A6BE83102A0EB3!812.entry-------------------------R... |
 |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2009-09-11 : 06:51:37
|
| rajdakshasite is not opening |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-11 : 07:07:52
|
That's the content:02 JuliSSAS cube report actions with ParametersHere is how you do it.Create the report action in the cubeServername: <servername>:<port>Report path: reportserver?http://<servername>/Reports/ReportsLibrary/<reportname>.rdlParameter Name: <name>Parameter Value: UrlEscapeFragment( [Dim].[Attribute].CurrentMember.MEMBER_CAPTION)This will pass the value as a string.In the report, create a parameter in the report data area- General: name, prompt, text, visible- Available values: none- Default values: noneIn the row groups, group properties, filters, add- Expression: [Dim] = - Value: @ParamName
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
SSAS CUBE