pietlinden (9/20/2016)

---

Here's a screenshot. Note the lack of individual tables in the field list on the right.

Every other time, the tables are broken out and then the columns are...

karen.ferrara (9/20/2016)

---

Has anybody used Bids Helper to deploy an SSIS package to the MSDB database? Three times I have used Bids Helper to deploy and it has changed the...

Steve Jones - SSC Editor (8/19/2016)

---

PB_BI (8/19/2016)

---

I've had an interesting scenario recently involving SSAS and nested Scope statements in MDX to provide calculation functionality for multiple calendars. I know it's...

Koen Verbeeck (9/13/2016)

---

Certainly agree on not updating large, fast changing transactional fact tables.

Regarding the OP's question: I think the grain of the fact table is one order (which can contain...

Koen Verbeeck (9/13/2016)

---

The type of fact table that you want is called an "accumulating snapshot".

It contains one row for each lifecycle (e.g. a customer that creates a specific order in...

Gregory Hart (9/8/2016)

---

It may be technically correct and logically validated that Hitler was one of the greatest leaders in all recorded history, but; such does not validate the horrors...

There is.....what I mean is that you can use SSAS...

ps_vbdev (9/6/2016)

---

yes id be truncating the fact table before every load. I have such difficult with understanding fact tables :angry: i would have never thought about splitting the dates into...

ps_vbdev (9/6/2016)

---

Hey thanks.

Im not doing an incremental load. so its a full load all the time so there wouldn't be a need to update the fact table they either have...

ps_vbdev (9/5/2016)

---

New to DW and still having trouble switch my brain over to it. Im wanting to report on the journey a user has from registering on our site, creating...

pietlinden (9/5/2016)

---

Bummer. That's what I was afraid of.

What do you do if the model is missing a measure or two and maybe some useful calculated columns? Call the developer,...

pietlinden (9/4/2016)

---

I've just started playing with SSAS Tabular 2016 after learning the basics of DAX. (I know enough to be dangerous, I think.)

It doesn't seem possible to "extend" the model...

Most of it should be - did you try clicking on the "Show Advanced (All) Properties" checkbox on the properties page?

It should be in a folder called Config in the Datadir location.

curious_sqldba (8/22/2016)

---

I haven't really played with memory settings on SSAS engine so is the question. Under the properities it is set to 65 and 80 for Lowmemory and totalmemory respectively....