Post reply

Possible external reporting solutions

  • August 24, 2011 at 5:03 pm

    #242760

    Greetings every one 😀

    I apologize if this is in the wrong category but I felt reporting services was not necessarily the proper topic for this :).

    So here is my situation; We have reporting services and data cubes set up for internal use. We send some of these reporting services reports on a weekly basis to our sales reps. Additionally we use a 3rd party online reporting service for our sales reps to use in order to do ad hoc reporting. We FTP the 3rd party solution on a daily basis.

    There are 2 major issues. 1) the cost of said 3rd party solution is more than we are willing to spend, and we feel, a bit much for our smaller organization and the amount of people we have. 2) Many people complain that the online solution is very difficult to use, not very userfriendly, and just generally problematic.

    One of the benefits of the online solution is its security. Our reps can see their own data, but not others data. While I would like to give everyone the ability to use the data cubes, there does not seem to be a way to isolate each reps data by security short of designing an inordinate amount of cubes.

    So to my question, what are viable solutions in this scenario? I know Reporting Services is not intended as an ad hoc solution, and the data cubes can't be (as far as I know) filtered by securities. I am assuming there is an alternative method short of paying a 3rd party vendor a gigantic fee, especially for a company of roughly 400 employees.

    Any help is appreciated thank you 😀

    Link to my blog http://notyelf.com/

  • August 26, 2011 at 5:45 am

    #1373679

    Check the section "Adding Security to the OLAP Cube" in this link.



    My blog

  • August 26, 2011 at 5:48 am

    #1373682

    You can also check this link[/url].



    My blog

  • August 31, 2011 at 4:54 pm

    #1375759

    Ignacio,

    Thank you very much for this information...after spending several days working on this I have successfully added all the intricate securities to my cubes!

    Thank you again this has been a great help!

    Link to my blog http://notyelf.com/

  • August 31, 2011 at 5:07 pm

    #1375763

    You are welcome! 🙂



    My blog

Viewing 5 posts - 1 through 4 (of 4 total)

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