aberndt (1/25/2012)

---

Martin - Thank you for the information. I have confirmed that SSRS is installed both on the server and on my workstation. I have inherited this server...it...

aberndt (1/25/2012)

---

I am trying to set up SSRS in my organization for the first time. I took one class on this over a year ago and am trying to...

Maybe you could limit the clients which the users can select as a parameter, by means of some mapping table. The procs will then just use the received parameters...

Either way,...

meaneyj (1/20/2012)

---

I have a website with that is currently running a large custom reports section. Some clients have been asking to have the ability to write their own reports. I...

Agreed...forgot about that for a second.

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...