MS SQL Server

SSAS - Dimension

How to process multiple SSAS cube dimensions in SQL Management studio

0

This is a little issue that bugged me…. instead of going in the Visual Studio project and processing dimensions in there, I wanted to be able to multi-select my dimensions and reprocess them.

But, multi-select is not something that you can do in SQL Management studio.

So… here’s the (hidden trick)….

  1. Select the dimension
    SSAS - Dimension
  2. Hit F7
  3. And then you have “Object Explorer Details” open, where you can do a multi-select.
    ssas_multi

You can also find “Object Explorer Details” in the “View” menu when you select the dimension.

Data warehousing and denormalization

0

Greetings. It’s been so long since I’ve even touch this blog that I write this first line with a touch of shame.

Ok… I’m over it now. 😉

I’ve been working heavily with SQL Server 2008 and with DB2 for the last couple of years. I really love my job.

Lately we’ve been working on a data warehouse project which is structured for reporting. This presented a new concept in my lap which at first I didn’t find to hard to comprehend, we I still don’t really, but it threw a wrench into the wheel I’ve been accustomed to.

– Data denormalization –

Writing SQL code for many years, for me, has been about creating relational databases where data is divided up and joined together in queries. Denormalization brings forth the concept of doubling data for the purpose of having it readily available. (Fast)

So the thought process has been different. Writing SQL jobs that will suck in data in the format that we require to build our warehouse (CUBE – Ready). I guess what this method really seems to be is a space vs time trade off. You have much more data, doubled up… but the result is that you can query it very fast.

The cube my co-worker created was really really fast. Slicing and dicing the data at the blink of an eye.

Data is only as good as it’s usability.

Truncate a table on a remote server in MS SQL Server 2008

0

I’ve been learning alot since I’ve been in my new job and I must say I love it.

I’m working with a completely different set of tools. For instance, most of the development I will be doing will be in .NET and looking in the occasional Delphi apps.

Over the years I’ve worked with MySQL alot and with MS SQL Server a bit (2000 and 2005).

In this position, I work with MS SQL Server 2008. And most of what I do is using stored procedures which is a switch from most of the solely web based apps I’ve done in the past.

I’ve been learning many aspects of MS SQL Server and how to work with link servers. While I’ve been learning, I’m only scratching the surface of what MS SQL can do.

So working with a linked server, I needed to truncate a table and fill it with data from another server.

I’m not sure this is the most elegant way, but this is what I came up with.

— Truncate the acuheader table
EXEC(‘TRUNCATE TABLE [Test_DB].dbo.thisTable’) AT [Link-Server]
— insert the data
INSERT OPENQUERY([Link-Server],‘SELECT * FROM [Test_DB].dbo.thisTable’)
SELECT *
FROM [Test_DB].dbo.thisTable

For those of you who haven’t used TRUNCATE, it is a much more efficient way to remove all table rows.

Basically, this combine with a Job allows to keep a table on another server in sync with another. Of course, you wouldn’t necessarily want to replicate your tables this way, the built in replication functionality is what you’d want for that.

But for the case this was used in, it seems to work fine and well.

I look forward to learning a lot more with MS SQL Server. It’s a powerful beast.

Go to Top