SSAS Reporting Action

Question

SSAS Reporting Action

brian118

Hall of Fame

Points: 3506
More actions
December 6, 2011 at 8:58 am

#144672

Hi
I'm trying to create my first SSRS reporting action in SSAS (2008), however when I either browse the cube from Excel or SSMS, I don't even have the 'Additional Action' listed down. I do have listed down other drillthough actions BUT not the reporting action. I've set the target type to 'Cells', 'All Cells'. I'me not sure if the report server and location are properly set since I can't even test them? Is this an issue? If these parameters are incorrect, the reporting action is not visibile? At this stage all I want is my reporting action to be visible so I can select it.
I'll appreciate your help to get me started...
Regards
Brian
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

brian118 Hall of Fame Points: 3506 More actions · Answer 1

OK made progress, not surely what I did BUT the reporting option is now visible in both SSMS and Excel, however I clearly now have a problem with the report path!

Server: xxxxxxxxxx/Reports_xxxxxxxxxxx/Pages/Folder.aspx?

Path: System/Finance Reports/Invoice

Supplying the above is opening the report manager (in the home folder) but not the Invoice report. The System/Finance Reports folders are hidden. What am I missing?

Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -

VA123 SSCarpal Tunnel Points: 4272 More actions · Answer 2

For server name enter just the name of the server without any path or aspx page.

For report path enter: ReportServer?/System/Finance Reports/Invoice

brian118 Hall of Fame Points: 3506 More actions · Answer 3

Patrick Womack (12/8/2011)
For server name enter just the name of the server without any path or aspx page.
For report path enter: ReportServer?/System/Finance Reports/Invoice

Thanks Patrick for your help. In fact now I can get the SSRS report to open successfully! It seems that if there is something wrong with any of the cube actions settings, the option is not visible while browsing the cube. In fact Benny Austin writes about it here [/url]

Now I need to pass two parameters to my report, one will reflect the cube cell while the other is hard-coded to -1. I tried with hard coding them to get me started however I'm receiving the following error when I open the report The 'xxx' parameter is missing a value

Isn't just a matter of entering the value in the cube actions parameter row? such as -1? because I can't get something this easy to work! Any help is really appreciated because it's my first Reporting Action and I would really like to get this working. Any links are also welcome.

Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -

VA123 SSCarpal Tunnel Points: 4272 More actions · Answer 4

Brian,

The answer to your report parameter question is in the link your provided. Look at Figure 7 - Supply Report Parameters.

brian118 Hall of Fame Points: 3506 More actions · Answer 5

Patrick Womack (12/9/2011)
Brian,
The answer to your report parameter question is in the link your provided. Look at Figure 7 - Supply Report Parameters.

Hi Patrick

Thanks for your feedback! I have tried to follow that link but still have problems...

I have attached 3 screenshoots

1) Showing the two report parameters; param_sbo_pk (String) and param_ins_pk (Integer), both hidden and not getting values from a query and without defaults.

2) CubeActions is showing the cube actions page. The param_sbo_pk is hardcoded to -1 from the cube parameters while the param_ins_pk is retreiving it's value from the cube.

3) Dimension image is showing the dimension (automatically built from the fact table) Invoice No and InternalInvoiceID which i need to pass to the report.

When I browse and click the cube to drilldown, the SSRS report is opening but I'm getting the error: The 'param_sbo_pk' parameter is missing a value. If I change the report parameters to visibile to check what values I'm passing, both are empty and therefore I think that I'm actually not passing anything!

Thanks for your help!

Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -

VA123 SSCarpal Tunnel Points: 4272 More actions · Answer 6

Brian,

Your report path still does not look right. Try ReportServer?/System/Finance Reports/TestReport

I'm hardly an expert at this, but typically I use dimension attributes as parameters instead of fact table keys.