Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Performance Problem from SSAS

Performance Problem from SSAS

Performance Problem from SSAS

I'm using SQL Server 2008 and Excel 2002 the Add-in for SQL Server Analysis Service.
I want to import a lot of data via a structured report and then use this data in the same excel file with VLOOKUP.
And there are a lot of VLOOKUPs and it seems to calculated after every cell that is imported.
I think it would help to switch the automatical calculation off. But then the add-in isn't working any more.
What can I do?

Thanks for every help.

RE: Performance Problem from SSAS

Perhaps look at what the end result of the VLOOKUPS are. Can many these not be pre calculated so you have a net measure available from the Cube?

You have the full scope of MDX and the ability to bring in other data sources into the cube via the DSV.


RE: Performance Problem from SSAS

Oh sorry I forgot to tell: I only have access via network to a specific cube and so I cannot influence MDXs, can I? Because I have no access to SQL Server itsself.
And there is not much that can be precalculated. I need all these figures in my excel sheet.

And sorry I don't know what DSV means, but would be very interested do know it.

But thanks for trying to help me. Don't give up on me.

RE: Performance Problem from SSAS

If you don't have access to the SSAS DB & the tools then my answer is no use to you and this probably isn't the place where you should be looking.

Looks like you are stuck with trying to sort out an excel solution.

DSV = Data Source View

RE: Performance Problem from SSAS

My solutions was now separate data import and using the data. The link between is done with an vba macro. So I import the data, take it and copy it to the sheet where the caculation is done.

But another solution could have been a stored procedure in the SQL server to pre-select the data on the server and then execute this stored procedure via vba macro and also have all needed data at once then.

RE: Performance Problem from SSAS

So your solution does not involve [SQL Server Analysis Service (OLAP)] then?

RE: Performance Problem from SSAS

As I said. I have no direct access to the server. I can only try to get the maximum out of the excel add-in.
But you are of course right. So I posted in the wrong forum. Should not happen again. Sorry.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close