Cannot open a local cube created with AS2005 in Excel 2003
Mon, 29 Sep 2008 07:32:01 -0700 (PDT)
Hi,
I've been struggling for days with this problem :
I've got an AS database running on AS2005, I can connect to it from
both Excel 2007 and Excel 2003.
I create a local cube with a "CREATE GLOBAL CUBE" statement, the cube
works fine in Excel 2007, but fails to open in Excel 2003 (SP2)
If I try to open ...
|
Exceeded the maximum number of partitions
Fri, 26 Sep 2008 03:30:11 -0700
Hello
I have following problem. In this server
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)
i get message
Errors related to feature availability and config ...
|
Key not found in set, can I skip it instead of name binding error
Thu, 25 Sep 2008 17:17:39 -0700 (PDT)
if a key isn't found in a set like {[Zone].[5],[Zone].[6],[Zone].[7]}.
Say 7 isn't found, then I'll get a name binding error. Is there a way
to return results for 5 and 6, even if 7 doesn't exist? ...
|
MDX Query for Search
Thu, 25 Sep 2008 15:51:01 -0700
Hi there,
I have dimensions with more than 5 mil records. I am using Proclarity to
Browse the cube. When ever users try to search particular Id in this
dimension, it takes really long time.
Is there any way i can write MDX query to search perticluar ID to speed up
the search or any other idea please ?
...
|
Hide Attributes without completely hiding Dimension Members
Thu, 25 Sep 2008 17:56:21 -0400
Let's say I have a Customer Dimension with three Attributes: "Customer
Name", "Customer Code", "Customer State".
All users should be able to view data related to all Customer Dimension
members. However, the "Customer Name" attribute should only be visible
when the "Customer State" is the same as the Stat ...
|
every 7 day column group
Wed, 24 Sep 2008 17:40:22 GMT
I need to create a column group for every 7 days within a date range.
So for the month of Sept. it would be
Sept 1 - Sept 7,
Sept 8 - 14 ect....
Thanks for the help.
From http://www.developmentnow.com/g/112_2003_8_15_0_0/sql-server-olap.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow ...
|
SSAS 2005 not using all available memory
Wed, 24 Sep 2008 10:13:43 -0700 (PDT)
I have a x64 machine with 64 gig of memory. It has SQLServer and SSAS
installed. SQLServer is configured to use 31gig of ram and SSAS is
configured with a TotalMemoryLimit of 31gig.
However, SSAS does not seem us use more than 2gig of ram. I have
check task manager and perfmon and they both show that it is ...
|
|
|
Biology Server for Bioinformatics - VADLO
Tue, 23 Sep 2008 22:48:06 -0700 (PDT)
If you are looking for a biology-related search engine/server, this
one is for you!
*New Biology Search Engine VADLO*
Site : Vadlo (http://www.vadlo.com)
Daily Research Cartoons: http://www.vadlo.com/Daily_Research_Cartoon.html
Description: Vadlo is a search engine for the biology/biomedical
scientists ...
|
How do I get AMO object in SQL'05 in VB6.0 ?
Tue, 23 Sep 2008 11:19:00 -0700
I have this application that uses DSO in SQL2000. But now we have converted
to SQL server 2005, but DSO object has been replaced with AMO object.
I did some searching and there are two dlls that may have this object:
microsoft.analisisservices.dll or msmgdsrv.dll
When I tried to register these dlls with ...
|
Number of active accounts
Tue, 23 Sep 2008 06:19:01 -0700
Hello all
I have a problem, that i cannot solve on my own, so i hope thta someone can
help.
I have a dimension table (Dim_Accounts), which is a slowly changing dimension.
It contains:
accountSCD_id (int)
account_id (int)
created (datetime)
status_code (int)
terminated (bit)
record_start_date (datetime)
...
|
