Any reason you are not using SSAS for this?

Aggregate fact tables can be useful, but make sure you are not creating a new table for every new report.

Without the table DDL and the execution plan, all we can do is guess.

Maybe you don't have the right indexes and you are doing scans instead of seeks...

sqlvogel (4/4/2014)

---

mishka-723908 (4/3/2014)

---

there are a total of about 60 measures. Most measures are basic. There are some that are derived from other measures and also depend on dim attribute types....

baal32 (4/4/2014)

---

When we say Excel are we talking about end users actually opening up Excel to view the dashboards or do you mean as an authoring tool? Our end...

You don't have to use linked servers.

blasto_max (4/5/2014)

---

Thanks. Would I be at a severe disadvantage in SSRS if I don't learn VB at all or learn just the bare minimum ?

I ask this because I'd rather...

Yeah, but c'mon, all the c# code is already in the article 🙂

Lempster (4/4/2014)

---

You could also use a 3rd party custom component such as the Checksum component from Konesans to calculate and store a checksum for the five address columns you are...

Check out Power View, the flashy looking self-service BI dashboarding tool. Power View is available in SharePoint, but also in Excel 2013 (but the data needs to be in Excel)....

What is your data source?

Nice question to end the week, thanks.

Yes, the secondary database is always accessible and readable.

You have to transfer the CDC change rows yourself though. SSIS 2012 has special components that help you with this.

Are you sure...

blasto_max (4/4/2014)

---

I have just started learning SSRS. To create a report, the first exercise tells me to go to Visual studio > Visual Basic > windows forms application. As...

You could use partitions, but since you have only 1 data source this would mean setting up linked servers, which I would try to avoid (performance wise).

You would also have...

If you have too many measures, you can exclude the derived measures unless they are really complex to calculate.

If they are easy to calculate, the front-end can do it.

Not sure...