SSAS Error while processing a dimension
Fri, 19 Mar 2010 11:10:38 -0700
I've been processing a dimension, and about half the time it will fail with
the error: "XmlaError: Server: The operation has been cancelled."
Running a trace, I see it's failing with this description: "Started reading
data from the 'Aggregation 3' aggregation." and an error number of 7.
I thought it was a ...
|
Long running and never ending query
Thu, 18 Mar 2010 17:05:01 -0700
Hi All,
I have a query that is reading through a large amount of data and I can't
get it to finish. In Profiler, I see activity at first (reads through
partitions and aggregations), then a long 'nothing' after 'Query Subcube'
event.
My DIM1 dimension has about 200,000 rows; DIM2 - 100, DIM3 - 230, DIM4 ...
|
usage based aggregation optimisation (SSAS 2005)
Tue, 16 Mar 2010 02:20:01 -0700
To minimise the impact for users we always process our cubes on server A and
then backup/restore them to server B.
Users only access server B.
Now I wan't to use "usage based aggregation optimisation". The user
statistics are obviously gatherd from the cube on server B. But I would like
to use these to opt ...
|
Currency format not showing in calculated members
Mon, 15 Mar 2010 11:17:02 -0700
Hi,
I have many calculated members defined as 'currency' in format string. When
I pull this calculated members in Excel 2007 they are not displaying the
currency format. However, all my measures defined as currency do show in
excel. Please advice.
Cheers,
Dave ...
|
upgraded field is crashing build
Fri, 12 Mar 2010 16:07:00 GMT
We upgraded some fields in our database, updated the DSV in the build saved
and ran the update and everything went off ok, until we ran the process from
the SQL Server Menu instead of BIDS interface. It still shows the field as
being to small and the build is cancelled due to a truncate error. I have
rebooted ...
|
cannot seem to delete SSAS database
Thu, 11 Mar 2010 13:31:01 -0800
I have been having some strange problems with our SSAS server and I suspect
something is corrupt there since it crashes without apparent reason, and last
night the AS service couldn't even start because some file is in locked state.
So I decided to delete the AS database and start from scratch but now I
can ...
|
Rollup Behavior
Tue, 9 Mar 2010 08:59:22 -0800 (PST)
I've created a few account cubes that roll up using unary operators
without issue. For example, when you drill down, the child sums up to
the parent.
100
--50
--35
-- -- 15
-- -- 20
-- 15
-- 5
-- 10
I've created a new one and for some odd reason, it is not summing up
all the way to the top. When I ...
|
|
|
Weird issue: databases not visible in managment studio
Mon, 8 Mar 2010 10:40:22 -0800
When connecting to the SSAS instance through Management Studio, I only see
one of 12 databases.
However, when connecting to the server through a client access tool
(Proclarity), I see all 12 and they're all available and queryable.
Anyone know what in the world is going on? I've rebooted and restarted the ...
|
Re: Error while trying to process cube with C# and
Microsoft.AnalysisS
Wed, 3 Mar 2010 10:36:02 -0800 (PST)
Hi,
Firstly, run the analysis services profiler at the back end, that may
give you some info.
And when processing through code, follow a procedure of first doing a
full process of all the dimensions and then the cubes. this would help
in most of the cases.
Sriram
www.sqllike.com ...
|
Re: Make 50,000 $-Dollar and more with 1 $ - Dollar
Sat, 27 Feb 2010 20:39:11 -0800 (PST)
SPAM ...
|
