Question about DrillThrough and Cube Schema Changes
Fri, 4 Jul 2008 16:41:00 -0700
Hi,
I am havily using AS2005 to build Cubes and size is really big( like fact
rows in 800mils and few dimension size is 7 mils rows). I have 2 challenge.
1. Once I change the cube structure, I have to go back and reprocess the
whole cube and it takes longer time. My requriments is this,
if i change th ...
|
Default value in a named set
Thu, 3 Jul 2008 07:23:01 -0700
Hi
I'm using a named set in a PerformancePoint Dashboard Filter and I need to
set a default value.
The named set is a slice of the time dimension with Year, Semester, Quarter
and Month levels, and I need to set the last month as the default value
Thanks
Ricardo ...
|
To many Cubes and dimensions?
Thu, 3 Jul 2008 00:30:36 -0700 (PDT)
I have an OLAP database with 150 cubes and each of the cubes have 12
dimensions. Response times of MDX queries are fine, but Processing
times of the cubes seems to be increasing as I add more cubes. If the
cube is the only one in a database it takes only a few seconds to
process, but when its in a database with ...
|
Vanishing Calculated Measure
Wed, 2 Jul 2008 10:32:48 -0700 (PDT)
I had a calculated measure called "Return%".
For testing purposes, I created another measure called "Return_%" with
an underscore in between "Return" and "%". I deleted the original
"Return%" calculated measure and renamed the "Return_%" measure to
"Return%". However, some reports which used the original "Retu ...
|
DSOCtrl works in SQL2005
Tue, 01 Jul 2008 17:44:11 GMT
Did anybody used DSOCtrl in sql2005?
Thanks in advance.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-olap/200807/1
...
|
Crystal Analysis get slow when 2users or more connect to SQL Analysis
Services
Mon, 30 Jun 2008 21:57:14 -0700 (PDT)
Dear Gurus,
When crystal analysis connect with 1 user crystal analysis to SQL
Analysis Services 2000, nothing wrong, it seems fine. but when 2 users
connect to analysis server, the application get slow.
is there any configuration that restrict 2 users connect to analysis
server ?
need help, thanks in adv ...
|
how to correct these errors?
Mon, 30 Jun 2008 17:59:01 -0700
while deleting a dimension, these errors show up:
"Errors in the metadata manager. The measure group with the ID of 'A**',
Name of 'A**' was invalidating by opertions in the tranactions.
"Errors in the metadata manager. The measure group with the ID of 'B**',
Name of 'B**' was invalidating by opertions i ...
|
|
|
cannot connect to server sql2005 Error
Mon, 30 Jun 2008 20:08:03 GMT
This the error i am getting while tring to connect to analysis server 2005.
Thanks in advance.
ConnectCube
OLE Automation Error Information
HRESULT: 0x80040001
Source: DSOCtrl
Description: Cannot Connect to Server ("WIN2K3SL70510") - [Server State :
stateFailed]
ALTER PROCEDURE dbo.LC_OLAP_Proce ...
|
SSAS handling calculated members in security roles
Mon, 30 Jun 2008 12:49:01 -0700 (PDT)
created a calculated member
CREATE MEMBER CURRENTCUBE.[Team].[Project].&[4446].Utopia
AS Aggregate({[Team].[Project].&[4474],[Team].[Project].&[4455],
[Team].[Project].&[4448],
[Team].[Project].&[4475],[Team].[Project].&[4520]})
Now created some security roles, but when I attempt to slice ...
|
Thoughts on providing a public cube?
Mon, 30 Jun 2008 07:04:53 -0700 (PDT)
I've developed a cube with SSAS of publicly available data and am
looking for ideas on hosting it.
Challenge 1 - PROVIDER - The provider that we use to host our SQL
Server database doesn't do analytics. We would rather not host it
ourselves.
Challenge 2 - ZERO-FOOTPRINT - I would like the user to not need ...
|
