recover command of Named Set
Tue, 5 Aug 2008 07:43:24 -0700 (PDT)
Hi,
i'm using the CellsetGrid2 ajax control which is really great.
Unfortunately it is using named sets for creating the cellsetgrid.
if i add several dimensions and measures one by one i could not export
the MDX statement because of the named sets being used.
the query looks like this
SELECT
{[Measures]. ...
|
Aggregations won't build in SSAS 2005
Tue, 5 Aug 2008 07:21:01 -0700
I have a SSAS 2005 cube which is sourced directly from Oracle queries using
the Named Queries feature. Cube builds fine with no aggregations. When I
apply the Aggregations Design Wizard it always returns with 0 aggregations
regardless of the design settings.
Does anyone have any idea/suggestion what might ...
|
should cube queries improve, after disabling its lowest level
Mon, 4 Aug 2008 09:02:00 -0700
Hey eb
Should i see a significant improvement in cube's queries perforemance,
after disabling its lowest level of ACCOUNTS(containing some 1 milion
members).
Next enabled level -TEAM - should contain some 3000 members only.
Other than that, cube's facts and structure will stay just the same,
that is - facts a ...
|
How to calculate Sum?
Mon, 4 Aug 2008 03:06:11 -0700
Lets say you have to plan capacities for two Teams per Week over two months.
For each week you have got target values and actual values in hours (h).
A table can look like this in 2008 for week 27 and 28:
Week 27:
Team A, actual 3h, target 2h
Team B, actual 4h, target 1h
Week 28:
Team A, actual 2h, targ ...
|
RE: Cube Partition Missing Measures
Sun, 03 Aug 2008 19:02:34 -0700
According to this paper on AS 2005 processing architecture, process
update of dimensions could clear indexes and aggregations in affected
partitions. You could try launching the "Impact Analysis" dialog
(described in the paper below) from the Process Update dialog for
dimensions, to see whether the old partition ...
|
Certification in Mind???
Sun, 3 Aug 2008 11:45:35 -0700 (PDT)
Hi All,
Certification in Mind???
Visit www.itjobguru.com for Latest Material.
Regards,
Naveen ...
|
Mutex error -- Cannot create mutex
Fri, 1 Aug 2008 01:27:59 -0700 (PDT)
How to resolve the problem when processing OLAP dimensions using the
parallelprocess utility we receive
the following error :
Processing Dimension 'Currency'; Build: 3.0.68
Processing (full) in Database 'ORa' at
DB-AS
Mutex error -- Cannot create mutex ...
|
|
|
Missing data in cube
Thu, 31 Jul 2008 22:11:41 -0700 (PDT)
I have a cube based on a fact table that is added onto each night via
an ETL process. Each night, the cube is reprocessed at the conclusion
of the ETL process. At one point, the ETL process was interrupted for
several days, and new data was not added into the cube. Once this was
discovered, I added back in th ...
|
.NET ADOMD connection speeds 2000 vs 2005
Thu, 31 Jul 2008 13:10:42 -0700
Is there a large difference between the time it takes to connect in C# with
AdomdConnection with sql sever 2000 and 2005/2008?
It's taking like 4-5 seconds everytime to make a connection and I gotta make
8 calls.
...
|
sharing adomdconnection sql server 2000
Thu, 31 Jul 2008 12:29:38 -0700
I'm getting a major performace hit opening up many Adomdconnections in .net
c#.
I'm trying to share the connection, but it seems to close everytime I close
a reader.
I have 1 class that does all the mdx query calls. I open the connection in
my constructor, but it doesn't seem to stay open.
I want to upgra ...
|
