I'm not familiar with Toad, but are you sure it's using the same driver?

tinnusqlserver (10/31/2012)

---

Hi All,

I am creating a SSRS report which directly gets the data from oracle.

I am running an oracle query in bids.

When i run this query in the "query designer"...

Jeff,

Thank you for that thoughtful reply; you make a good point about having to sell/justify the change with ROI. I can create a template package that will/should be easy...

Kayal-717623 (10/31/2012)

---

Hi all,

I have a master package to execute 200 child packages. The master package goes thru a loop and executes 5 -6 packages at a time. The...

You can also install Report Builder 3.0 to create your SSRS reports.

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=6116

Rob

scottcabral (10/30/2012)

---

Hi,

I built a dimensional model with the fact and dim tables populated and created a cube using SSAS 2008.

Now I would like to give the end user's the...

niha.736 (10/29/2012)

---

problem has moved a bit forward , But strucked over a little change

=IIF(CInt(ReportItems!Sales38.Value) > 99999, ReportItems!Sales38.Value, FormatNumber(CDbl(ReportItems!Sales38.Value),"N2"))

this is the expression i have written. with help of this am getting...

Use an expression like:

=CInt(Ceiling(RowNumber(Nothing)/4))

Then put this into a group and set your page break as you wish for that grouping.

HTH,

Rob

grasshopper26 (10/29/2012)

---

I am newbie to SSAS

I am trying to understand the following sentence from SSAS cube i just built

"Avoid defining measure groups with zero dimensional overlap" ...

Try something like:

=IIF(Fields!YourField.Value < 99999, FormatPercent(Fields!YourField.Value), CInt(Fields!YourField.Value))

I haven't tried this, so you may need to play around with this. But it should give you a start.

HTH,

Rob

One way to do this is to create a Calendar or Date table.

Take a look at: http://weblogs.sqlteam.com/dang/archive/2010/07/19/calendar-table-and-datetime-functions.aspx

HTH,

Rob

Charles, investigating further, it doesn't appear that parallel processing is allowed (see attached screen...

Yes, you can query a SSAS cube...

richykong (10/25/2012)

---

Only thing I can find is that SQL 2012 Multi Dimensional supports up to 3 partitions under the Standard license. Are you sure you're not possibly running 2012...

I don't know if it allows for parallel processing -- where would I check...