seaport (6/12/2015)

---

I have a cube for counting # of members in different ways. The measure is "Member Count", which is the count of records. I have two choices for creating...

Think of the calculated measure as a pseudo-cursor. When iterating, it needs to use the member it is currently on (in the iteration) for the comparison to work. Try to...

Not as far as I know, with Power Pivot only. You may be able to do something with Power Query, and then use the results as input for your Power...

I haven't tested this, but how about something like:

...and SetToStr([Dim Date].[FSCL_YR].[FSCL_YR].currentmember) = "[Dim Date].[FSCL_YR].&[" + Format(now(), "yyyy") + "]"

g1696412 (7/2/2015)

---

Hello,

when dealing with building BI solution, respectively database structures for it, should Key elements (=used for joining tables) be named as KeywordID or IDKeyword? I used to use IDKeyword,...

Debbie Edwards (7/2/2015)

---

Fact Table

DiagID PersonID Fact_PeopleWithDiagnosisThisYear

1 7808...

These properties apply only when the dimension itself is processed,...

Just a thought, but could it be possible that your FTP task starts transferring the file before the archive is complete? To eliminate/test whether this is indeed the case, include...

In my opinion, a simpler approach would be to create a stored proc which contains all the sql statements you wish to execute. That would simplify the SSIS package as...

Could you post the details of the "Dimension Usage" in your cube? This is where many:many relationships have to be defined in your cube.

Jim1234 (6/11/2015)

---

Hi,

Below is the scenario,

•I'm calling the SSIS packages through SQL agent job. The packages have variables defined with default values.

•The parent packages have no package configuration. The child...

Can we add the address too please...feels somewhat incomplete without it 😀

Yes, either build a deployment package (choosing not to overwrite the roles and members...or add the roles and members into your SSDT project.

In that case, your only option to force the execution in 32-bit mode is to use either T-SQL or CMD Shell command to initiate the package.

You could do something similar to the following post maybe: http://www.sqlservercentral.com/Forums/Topic1668379-17-1.aspx#bm1668991