ttdeveloper (3/13/2015)

---

Hey Steve

Thanks for getting back. What I am trying to see is this. I pull up the AD hierarchy where Joe is and I see only one entry of...

No, there is unfortunately no way to run that task "interactively".

Marcus Farrugia (3/12/2015)

---

Hi, I have a Derived Column that transfers a 'number' in a unicode string[DT_WSTR] data type to a Data conversion task the input column value is .0786 and...

LittleKitten (3/12/2015)

---

Thanks.

I did have this working but instead of using a SET I used separate members to do the dates like I did in the WHERE slicer

and this worked out...

You are creating 2 mutually exclusive sets of dates here. The values of the calculated measures are determined after the data is filtered by the where-clause.

Think of it this way...first...

touchupboy (2/25/2015)

---

The subject kind of spells out what I am looking for. Attached is an example table image of an example of the issue.

The ACTUAL answer I'm looking for...

No, Excel and SSRS are 2 very different platforms.

JP10 (3/10/2015)

---

Hello,

I have excel 2010 with a regular pivot table. Is there a way to covert that pivot table into t-sql code so I can plug it into SSRS....

I'd recommend reading Chris Webb's blog posts on the subject: https://cwebbbi.wordpress.com/2013/05/23/using-scoped-assignments-to-show-calendar-and-financial-year-to-date-values-in-the-same-calculated-measure/

If you're still having issues after that, please post your results (and expected results) so that we can get a...

I haven't ever had the need to implement dynamic and custom security for a cube, but in my opinion you would have to do it all at the lowest level.

You...

And a follow-up question: Why are you using OpenRowset?

Users should be able to connect directly to the SSAS instance either through Management Studio or Excel.

BTB (3/9/2015)

---

Sorry for lack of detail. We have never allowed any user to query a cube using a select (openrowset in the users case). when i run i get results...

BTB (3/9/2015)

---

Hi All,

I have been searching high and low and cant find how to solve this problem i have with ssas permissions. We have a couple cubes we want to...

Probably has to do with the fact that it is showing all tables within all schemas. You may want to change your connection string to connect to the schema you'd...

That may be a better question for the Oracle forums.