Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
group : microsoft.public.sqlserver.olap      view archive
page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>



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 ...


page nr.: page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>
Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us