ProClarity Web Standard Auto Apply
Wed, 11 Jun 2008 06:32:01 -0700
Is there a way to have ProClarity Web Standard not Auto Apply when changing a
slicer? I know how this is done in Professional, but I was curious if this
can be done in Web Standard. There is an Apply button for when changes are
made to the sorting and filtering.
Again, I'm asking if this can be controlled ...
|
Calculated Member or Named Query
Wed, 11 Jun 2008 09:50:49 +0200
Hello!
Let's say that in your order dimension table you have a customerID.
Now in your dimension you would like to include the customer name instead,
because it looks better.
How do you do this?
I tried to add a calculated member with a "select customerName from
customers cust where cust.customerID = ...
|
Using distinctcount on a slice
Wed, 11 Jun 2008 00:10:31 -0700 (PDT)
Hi.
I want to use the distinctcount function to get the distinct count of
campaigns in a given time.
The following expression gives me the total distinct number of
campaigns at all times, but I want the distinct number of campaigns
only for a given period. How to do this in MDX?
WITH MEMBER
[MEAS ...
|
Re: Aggregation Designer is not increasing Performance
Mon, 09 Jun 2008 16:44:26 -0700
Well, good for you then - but, according to this document, Aggregation
Usage should only be set to "Full" in special cases:
http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7
151b2011c/SSAS2005PerfGuide.doc
>>
Analysis Services 2005 Performance Guide
..
? Change the value of the Aggreg ...
|
geomean
Mon, 09 Jun 2008 09:51:19 +0200
Hi there
Anybody has some working MDX for a geometric mean?
the only thing i got to work was this:
(
(1+([Year].[Year].Currentmember,[Measures].[Composite Growth]))
*
(1+([Year].[Year].prevmember,[Measures].[Composite Growth]))
)^.5
i tried to use excel's GEOMEAN or PRODUCT functions, using sets s ...
|
SQL Server Default OLAP group
Sun, 8 Jun 2008 01:18:01 -0700
Hi,
One of our client installed sql server 2005 in clustered environment. I
need to configure the OLAP Data analysis for project server. When try to find
the SQL default group "SQLServer2005MSOLAPUser$<SERVERNAME>$MSSQLSERVER"
which will be automatically added during installation. I checked in the
local ...
|
Can users use a SSAS cube in SSRS 2005?
Sat, 7 Jun 2008 12:13:57 -0700 (PDT)
It seems so simple, but I cannot find a way to do it - maybe it cannot
be done...
I have a simple OLAP Cube built in SSAS 2005.
I have successfully deployed the cube from Visual Studio 2005 to a
server with both SSRS 2005 and SSAS 2005 on it.
I have a series of SSRS reports with a custom front-end to deli ...
|
|
|
Linked Server Error: 'MSOLAP' did not provide an appropriate inter
Fri, 6 Jun 2008 13:14:00 -0700
SQL 2000 SP4 with AS 2000 SP4.
Create linked server to FoodMart 2000 OLAP DB called "FOODMART".
No problem to execute query (note no "on Rows"):
SELECT *
FROM OPENQUERY(FOODMART, 'select {[Measures].Members} ON COLUMNS
FROM Warehouse'
But for query:
'select
{[Measures].Members} ON COLUMNS,
Desce ...
|
Aggregation Designer is not increasing Performance
Fri, 6 Jun 2008 11:54:03 -0700
I have a cube that has approximately 2.5 million rows with 54 dimensions and
24 measures. My problem is this cube seems to move much slower then the rest
of the cubes we have. All have primary and secondary keys defined and are
utilizing the proper indexes.
Every time I run the Aggregation wizard, it ru ...
|
Cannot use the Scope_isolation key word with Cell Level security
Fri, 6 Jun 2008 11:41:27 -0700 (PDT)
Hi,
I can't seem to use Scope_isolation key word with Cell level security.
If you run the following MDX:
With
Member [Measures].[test] As '0',solve_order=20, SCOPE_ISOLATION=CUBE
Select
[Measures].[test] On Columns
From [Adventure Works]
With a role that contains cell security
you' ...
|
