Have you considered building the flags into a type-2 dimension for stores?

You would require the logic in your ETL layer and drive type-2 changes based on the different rule...

Yes, on all accounts.

In terms of your last comment: I typically process the type 2 (history) dimension first, and then perform a merge on the current version records with the...

There's a few different approaches you could take here, and it really just comes down to preference.

The one constant thing is that you will need a type 2 SCD, to...

If you see the same measure value for all of the employees in your list, the most likely problem is that you do not have the relationship defined in the...

I am unfortunately not seeing the same behavior when using your sample data and setting the "Summarize By" option in Power Pivot to "Average".

I'd recommend that you check the following:

Data...

david.gugg (9/14/2015)

---

Thanks, that does help but also raises some additional questions:

1. If I'm putting this on a separate server than the ODS, I'm going to need to license 2 additional...

A little tough to accurately spec a server, given that some of the details are still in flux. Here's my general recommendations though:

SSAS requires a lot of resources, especially with...

Hi Dave,

In order to size an Analysis Services server, you'd need to follow a similar process to what you will do with the sizing of a database server. In light...

It's a little tricky to do this in Analysis Services, due to the dimensional nature of cubes.

I would create 2 sets: One that returns the combination of "Bikes" and "EU",...

HookSqlDba7 (9/10/2015)

---

With SQL Server 2014 EE SP1, using Project Deployment and a SSIS Project with 20 packages. You change only one package. With Project Deployment will it redeploy all 20...

rc 77550 (9/10/2015)

---

I updated the fields used in the aggregate with convert(decimal(38,15),decimalfield) in the facttable.

Then processed the dimensions, and then the cube.

But I get the same error.

Shouldn't this fix the...

ilovedata (9/10/2015)

---

Thanks for the guidance, Once I am able to get the answer I will mark it as solution. it will be really helpful if you have a sample query...

Herein lies your potential issue...your source data may not be compatible with the data type in your cube. Please see the following: https://technet.microsoft.com/en-us/library/gg471558(v=sql.110).aspx

Also look at the Levels function, which allows you to return a specific level within a hierarchy. Combined with the Descendants function and assuming you know which levels you need...

Still seems to be the same "Conversion Overflows" error. You either have really large numbers in your measure group, or there is some bad data that cannot be converted to...