Analysis Services Report actions and SharePoint Integrated Mode Reports

This is one of those things that you can easily get wrong from time to time, (I have Smile), so thought I would share it on my blog and hopefully it will save some of you from facing the same issue.

When you have Reporting Services running in SharePoint integrated mode and you want to enable an action on a Analysis Services cube to a report on this reporting services server, you need to ensure you configure the Report Server properties correctly for it to work.

Essentially the format for this dialog box in BIDS for the Cube Action settings are:

Report Server

Server name: <name of reporting services server>/reportserver (default directory)

Report Path: <name of reporting services server>/reportserver?http://<sharepoint server name>/reports/<reportname>.rdl

Below is an example and screen shot:

Report Server :  http://mgsir37-02/ReportServer_WI

Report Path    :  http://mgsir37-02:2/Reports/Company Dashboard.rdl

Cube Action settings


Comments (6)

  1. Anonymous says:

    Can you let me know the same for SSAS 2012 with Sharepoint 2013

  2. WQ says: Sure, the process of flinging a spinnerbait may catch a rogue fish off of nothing here and there, but I’ve found that during the course of the average true cover-seeking day, your only looking for a few extra bites from “between” bass. I’d rather be locked and loaded for the gentle pitch, then carelessly unleashing the firing– squad. What I mean is that in most cases I’d rather be putting along “between” at a moderate pace with the same jig in my hand that I had success with on
    http://www.burberry– the docks all day, and looking for that unique cast/pitch to something

  3. aw says: Lowongan Kerja Management Trainee Lowongan Kerja Depnaker Lowongan Kerja Terbaru Lowongan Kerja Dokter Lowongan Kerja Terbaru Lowongan Kerja Dosen Lowongan Kerja Terbaru Lowongan Kerja Elektro Loker Terbaru PT. Wijaya Karya (Persero) Lowongan Kerja Bulan Desember PT HM Sampoerna Tbk Lowongan Kerja D3 Lowongan Kerja PT GMF AeroAsia Lowongan Kerja PT. Nindya Karya (Persero) Lowongan Kerja Garuda Indonesia Lowongan Kerja Asuransi Lowongan Kerja Hari Ini Lowongan Kerja PT Pertamina Retail Lowongan Kerja Hukum Info Lowongan Kerja Staf Hubungan Industrial PT Pertamina Retail Lowongan Kerja BPJS Kesehatan Lowongan Kerja PT Pelayanan Listrik Nasional Lowongan Kerja IT

  4. aw says: Lowongan Kerja PT Indosat Tbk Lowongan Kerja PT PGN persero Lowongan Kerja PT Pelayanan Listrik Nasional Lowongan Kerja PT Sigma Caraka Lowongan Kerja PT Sucofindo Strategic Business Unit Laboratorium Lowongan Kerja PT. Nindya Karya (Persero) Lowongan Kerja PT. Sinar Sosro Banyak Posisi Lowongan Kerja SMA/SMK Universitas Negeri Yogyakarta Lowongan Kerja SMK/SMA D3 S1 PT PUPUK KALTIM Lowongan Kerja STM SMA SMK PT Darma Henwa, Tbk Lowongan Kerja Sarihusada Generasi Mahardhika 2 Posisi Lowongan Kerja Telkom Management Trainee Program Lowongan Kerja Terbaru 2016 PT Yamaha Indonesia Motor Lowongan Kerja Terbaru PT Menara Terus Makmur Lowongan Kerja Terbaru PT Pembangunan Jaya Ancol, Tbk Lowongan Kerja Terbaru PT. Astra International, Tbk Lowongan Kerja Terbaru PT.Asuransi Jasa Indonesia (Persero) Telkom Career Program 2016 Walk in Interview Frontliner Bank Mandiri Lowongan Kerja D4

  5. dongdong says: