Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Analysis Services Cube Automation to browse from Excel Expand / Collapse
Author
Message
Posted Wednesday, October 02, 2013 7:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 28, 2013 7:21 AM
Points: 4, Visits: 19
Hi all,

I have a system, like I have database, I make cube. When I had to make some changes in database, I need to "Process" cobe and then only I can see the changes in my Excel sheet.

If someone can help me please, I want to make my system in this way so that, as soon as I make any changes in my database, I can see the changes on the excel sheet, with some information, like, where(table name) the changes has been made, how many rows and/or columns has been changed. That means I will change only database and I don't need to process the cube. I will just check the Excel sheet the get all information.

Best Regards,
Post #1500782
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse