|
OWC IDE Frontpage, etc
team;
I do a lot of dev with OWC, and I would like to make sure i use the best
tool.
I haven't had much luck with the WebMatrix; and dreamweaver won't really let
me set the properties of the ActiveX control at design time.
i have previously used Frontpage2003 with OWC 11; and it worked like a
charm.
...
Mon, 29 Nov 2004 10:44:08 -0800
|
Data Usage Auditing
Ib m starting to look at using a data warehouse and would like to have some
tracking of the queries ran against the data warehouse.
Ib ve gone through several articles about the MS Access database msmdqlog.mdb
and Ib m just looking for ways to implement the auditing and I have a few
questions.
I gues ...
Mon, 29 Nov 2004 12:47:07 -0800
|
Cube Partions
Can anyone tell me why the cube partition processing fails when I use a view
as the fact table, and partition it with a data slice. We have one large
fact table, which is created through a view. This works fine, but when I try
to break the cube up with a data slice based on month, I get the following
error:
...
Mon, 29 Nov 2004 11:28:03 -0500
|
Can someone explain what the issue is
right here goes, i have a set of cubes, none of which is greater than about
100MB. one in particular is causing a real headache
System
2 1.7 Ghz XEON CPU DL 580 - RAID 10 storage with SQL enterprise SP3, 3GB RAM
fix and is dedicated to cube processing
the Problem Cube
3 dimensions and 4 measures
...
Mon, 29 Nov 2004 07:33:10 -0800
|
Calculated measure COUNT
Hello!
My MDX Query looks like this:
WITH
MEMBER [Store Type].[COUNT] AS 'COUNT(([Store Type].[All Store
Type].Children))'
select {([Store Type].[All Store Type].Children),([Store Type].[COUNT])} on
rows,
{([Customers])} on columns
from Sales
And it works fine :) (COUNT value is 6)
but when I add me ...
Mon, 29 Nov 2004 13:04:16 +0100
|
Calculating Max Usage with OLAP
Hi,
We have a critical problem with the query performance of a calculated
measure that uses the Max function over a time dimension that includes
members till the hour level.
The current solution that we have includes:
1. A measure (i.e. UsageSum) that sums up the usage with all of the
dimensions
...
Sun, 28 Nov 2004 16:10:49 +0200
|
)J+=+=
$_+d+d8UE% +86 13180152666
...
28 Nov 2004 12:28:59 GMT
|
OLAP cubes computation will NOT terminate
Hi,
We have the case on a PRODUCTION Server where from time to time,
the OLAP cube recomputation (each night) invoked inside a DTS
may not terminate after 10 hours (normal CPU time is 2 hours).
Does anyone knows if there is some known issues in MS support or KB ... or
real life.
If it become more freque ...
Fri, 26 Nov 2004 19:11:53 +0100
|
Critical AS 2000 defect: Analysis Manager crashes
To reproduce this defect, create a cube with a number of shared
dimensions, such that the sum of the total number of dimensions and
the total number of measures is greater than 135.
Create a cube and add these dimensions to it and set appropriate
joins.
Create a command line action to be invoked on individual ...
26 Nov 2004 09:28:41 -0800
|
Date format in drillthrough
Can anyone tell me where the date formatting is set in drillthrough?
Does it just come from the source SQL Server or is there anyway of
overriding it?
Thanks,
Paul
...
26 Nov 2004 07:40:56 -0800
|
Urgent: Automation error
Hi !
Everything was working fine until today when I start Analysis Manager and
recive:
'Automation error'
'The specified module could not be found'
OLAP server is still OK. BI portal is working fine, but I can't edit any
cube.
Does anybody knows what is going on.
Thanks in advance,
Regards
Vla ...
Fri, 26 Nov 2004 11:47:54 +0100
|
anonymous connection from excel to cube not working
Hi,
This is driving me nuts:
Within my company, I try to connect from excel to analyses server (2000 all
service packs are installed)
Because the users that have to access the cube are not in the same domain I
want to allow anonymous access.
I can make a connection to a test server. (By ena ...
Fri, 26 Nov 2004 09:50:51 +0100
|
BI Portal translate
Does anybody knows if there any way to translate the BI Portal Languaje
Thanks ...
Thu, 25 Nov 2004 11:39:02 -0800
|
Inexplicable termination of Analysis Manager
Hi,
In a cube, we have created a cell action. The action statement as
entered in the cube designer is:
"cmd /k dir"
We process the cube and display the data in Analysis Manager. However,
when we right click on any cell in the displayed table, Analysis
Manager crashes. It just vanisihes from the screen.
T ...
25 Nov 2004 10:05:47 -0800
|
Is there a limit to number of individual accounts in a role?
Thanks,
Igor
...
Thu, 25 Nov 2004 17:28:06 +0100
|