shannonjk (9/7/2011)

---

I was able to figure it out right before you posted :-D. I did this in SSMS and the problem did not replicate. I did a ping from my...

shannonjk (9/7/2011)

---

This is happening to all users. I believe the users have a fairly decent connection to the data cubes. The overall speed of the cubes seems to be on...

Is...

this too

not sure what you mean by "in the form of Report"...are you talking about an SSRS report?

bhushan_juare (8/26/2011)

---

2) Use KPI in Excel...

this looks wrong...maybe its just the naming of your objects...

is your dimension name "time"?

is your user hierarchy name "day"?

is "Fiscal Year" a level in your user...

does it only happen when the users filter on columns with many members?

are these members at the same granularity as the key?

are you sure your attribute relationships are...

vinayak.v (8/29/2011)

---

what i want is if i execute the SP for First time in Execute sql task

it should return the value 1 and next time if execute it should...

not in 2005. in 2008 r2, there are new system variables that can help with this.

sounds like you just need to add the an additional output column to the script component to account for the input column (modified date).

"What are your hobbies? / What do you enjoy doing in your free time? / What blogs do you read?"

ToddFields (6/24/2011)

---

SSRS: No end user is able to use this tool. Take report builder 3.0 to the river and drop it in. Reporting needs to be self...

My group (BI Dev/decision support) implements very basic auditing into our solutions that only gets reviewed in the event of an issue...so 100% reactionary. The main purpose of our...

here's what I was thinking...not sure if you need the calc-measure to return anything when not being sliced by any other dimension (or level in the time dimension).

warning: not...

Raunak Jhawar (3/3/2011)

---

But what if they have different types of promotions and would like to analyze the effectiveness? ...