Viewing 15 posts - 16 through 30 (of 113 total)
I have also seen something similar when we were using 32-bit SSAS and this stopped happening when we moved to 64-bit SSAS and the extra RAM that came with it
I'd...
March 14, 2013 at 10:43 am
Have you looked at the SQL it is running at the time?
I've seen something very similar when our weekly SQL server maintanence jobs failed for several weeks (I didn't have...
March 14, 2013 at 10:35 am
Pretty sure there isn't a setting to fix this in the cube - it sounds like Excel is auto-converting this not SSAS telling Excel that it's a number
The only thing...
March 1, 2013 at 9:56 am
What makes you think it is a memeory leak?
SSAS will start to cache queries in order to improve the performance of the queries (this is good!). There...
March 1, 2013 at 9:47 am
Good point Phil.
Maybe a script task would be a better option as it is database independent.
Mack
February 26, 2013 at 4:00 am
Just out of interest, how would that work if you wanted to change the database name?
Mack
February 26, 2013 at 3:28 am
The only ways I can think of doing this are by generating & running dynamic SQL statements either through a stored proc (passing the table names as variables) or a...
February 26, 2013 at 3:05 am
A dimension will be the quickest way as it will continue to use aggregations across your data. If you try to limit the data against a low level data...
February 25, 2013 at 9:55 am
Why not create a "Valid" dimension that is hidden from the users and base your security of that?
Mack
February 25, 2013 at 9:27 am
Ahhh - ProCalrity won't be giving you one row but ProClarity does allow you to sum across a set if you put it in the background and combine items (this...
February 19, 2013 at 4:37 am
No, you don't just want a set
You have two real options here
Option 1 is creating measures such as Gross Revenue YTD, Net Revenue YTD etc (depending on the measure...
February 18, 2013 at 9:49 am
You either need to create a member such as below and report on that
create member [Effective Date].[Dates].[YTD] As
Aggregate(
StrToSet("YTD([Effective Date].[Dates].[Date].[" + CStr(DATEPART("YYYY",NOW())) + "-"
+ Right("0" + CStr(DATEPART("m",NOW())),2) + "-"
+...
February 18, 2013 at 9:05 am
What do you want the SQL task to do? Update the column?
If so the SQL needs to be
Update table_name
Set stage = REPLACE(Stage,'Closed Won','Awarded')
Mack
February 12, 2013 at 7:45 am
That's how I do it - see attachment
Mack
February 12, 2013 at 7:38 am
Your SQL statement needs to be a proper statement ie
Select REPLACE(Stage,'Closed Won','Awarded')
from your_table
What are you trying to do? An update? Assign a variable?
Mack
February 12, 2013 at 7:27 am
Viewing 15 posts - 16 through 30 (of 113 total)