Jako de Wet (1/20/2012)

---

Hi everyone

This is probably a very stupid question, but once you have created your SSAS cube, how do you let your clients browse it online?

Ideally I would...

Create a Row Group, and in the properties of the Row Group (Page Break section) you will be able to check the option that will force a page break between...

TemporalCraig (1/19/2012)

---

Martin,

I think the important thing is that the fact table compression technique and SQL support for temporal data are pretty different topics (related but different).

The “dated” part of the...

Hehe...sure...anytime 😉

Glad I could help a little...that's what this forum is all about.

mulukenn (1/19/2012)

---

Oh yes, that is great. I hate anything that affects performance ;-). But again, what do you think if I denormalize those tables into the table which is used...

mulukenn (1/19/2012)

---

Hi Martin,

Thanks. Yes that was my question and you answered it correctly. It helps a lot.

In addition, this dimension will be joined to many fact tables. There are...

mulukenn (1/19/2012)

---

Hi All,

I have a large dimension, with approximately 60, 000 records and a growth rate of 1600 a day (put another way, there will be around 1600 changes everyday)....

Interesting comments, and thanks for the references Craig.

I will browse through your site in more detail a little later. I understand the notion that this concept isn't new by any...

joubert.terence (1/19/2012)

---

Hi

I am building an SSRS report using Report Builder 3.0.

The report shows an list of orders. I want to add a button on each row(record) that when clicked by...

I would agree with David that the topic of temporal data (and how to manage it) is not new. It has been around for a very long time. In my...

Yes, I am currently using a similar type of design in a very specific application where it would not have been feasible (or even possible) to do daily snapshots.

There was...

It is because you are passing a null value of the wrong type. You cannot use DT_WSTR in this case, because the destination field is expecting an integer value.

winston Smith (1/11/2012)

---

I have read the SSIS Package Configurations MSDN Article (http://msdn.microsoft.com/en-us/library/ms141682.aspx) and it states that:

You cannot use the /ConfigFile option to load configurations that replace the configurations...

winston Smith (1/11/2012)

---

Ive read online how you can set a variable as "sensitive" in SSIS so that, depending on the protection level, its data will not be stored.

I cannot figure...

manivannan.kariamal (1/11/2012)

---

Thanks for the reply.

My dimension is having 5 billion records and 27 columns(apart from the columns I've given). If we change the relationship to 'flexible', will it affect the...