For your second question, it seems like the scenario is very similar to a temporal fact table. As the other gentlemen mentioned, it seems like most the components for the...

Yes, please provide screenshots of your tables and relationships.

pietlinden (9/26/2016)

---

Oh okay. Thanks for the clarification. I guess I should learn a little MDX eventually... just so much to cover and so little time! (and not enough brain cells...

Yes and no...there are things you could do much easier with MDX than with DAX, especially when dealing with...

Small correction to the above. You...

gwfenton1974 (9/19/2016)

---

I think I am missing something as when I use the attributes outside of a hierarchy they roll up perfectly. When I drop them in a Hierarchy leaving the...

gwfenton1974 (9/16/2016)

---

Is there any way to make this work in your scenario across multiple ID's eg Tenant A and B.

I have a scenario where I have a different product ranges...

You will need to check your keys, relationships and dimension again. As the error states, it cannot find the dimension member with a surrogate key of "62" in the dimension.

Browse...

Interestingly enough, the behavior is due to the attribute relationships and not the hierarchy. Have a look at the following post...following a similar approach would give you the required behavior:...

It should, but if that person has administrative rights on their SSAS instance (which they should if they can restore)...they would be able to remove those roles or change them.

I...

sammane (8/20/2016)

---

If we start with dimensions, are we saying all dimensions only contain unique distinct records, for example I have 10 customers and 15 products, does this mean my DimCustomer...

mcfarlandparkway (8/24/2016)

---

OK, I processed the table as well as cube as you say. May I know the syntax for tabular cube to see the data.

is it starts with evaluate or...

https://msdn.microsoft.com/en-us/library/hh213155.aspx

As the error suggests, you need to process the tabular cube first. The structure is deployed, but without processing the cube there will be no data.

sspaeti (8/22/2016)

---

For example if I tried with the "Siglum Internal" then one problem was, that I could only count if the "Siglum internal" was shown on the result table. But...