|
Help writing MDX
I have two cubes Billings and Refunds.
Billings measure: Billed$
Refunds measure: Refund$ and Billed$withRefunds
I create a virtual cube BR which has all the above measures.
Situation is
1. Not all billings will have refunds.
2. One billing can have multiple refunds.
3. All the billings dimension are c ...
Thu, 13 Jan 2005 10:17:53 -0500
|
OLAP Connectivity problem
Hello,
I am facing one problem of connecting to the OLAP Server.
I am using ASP.Net and ADOMD.Net to connect to the OLAP Server.
My OLAP Server is on "Server 1" having domain "Domain 1". And the Web Server
is on "Server 2" having domain "Domain 2".
What I think is as both the servers are having differen ...
Thu, 13 Jan 2005 05:43:06 -0800
|
Derived expression in Yokon
Can anyone help me out with a Yuokon AS query?
MeasureExpression in measure properties does not seem to allow if statements anymore. How so we arrive at a conditional derived expression now?
thanks
--
Message posted via http://www.sqlmonster.com ...
Thu, 13 Jan 2005 13:14:01 GMT
|
Please help - recovering a Analysis Server database after a hard disk crash
The Server running our Analysis Services had the local hard disk
crash. I do not have any backups of this development server.
Thankfully the Analysis Server databases were on a disk I have managed
to recover the entire folder:
C:\Program Files\Microsoft Analysis Services
I have the Bin and Data directories ...
13 Jan 2005 02:54:40 -0800
|
Can't activate html view (getting started / metadata)
Hello all,
I'm having a problem with Analysis services and the following is the case.
In AS in the menu under view both "details" and "html" are active. Because
they are both active AS automatically uses the explorer type view.
It is not possible for me to deactivate one of them via the menu.
I have alrea ...
Thu, 13 Jan 2005 02:25:01 -0800
|
performance with owc and large dimensions
Hi,
I've a large customer dimension with levels:
type 4 members (unique keys/names)
customer 150' members (unique keys/names)
I'm planning to impement one or two dummy levels (not
unique level keys/names):
name first char 130 members and/or
name first 2 chars 1300 membe ...
Thu, 13 Jan 2005 02:03:22 -0800
|
measure displays no data
Hi team,
We have a OLAP cube build on Oracle VIEW. It has 1
dimension and about 5 measures. When the cube is process
and the data is displayed, the dimemsion displays the
correct data. Out of the 5 measures, only 2 display data
in it. The rest 3 display 0. In the Oracle VIEW, all the
5 fields have the s ...
Wed, 12 Jan 2005 11:43:11 -0800
|
OPENQUERY for Linked Analysis Server
I'm gathering information on OPENQUERY for Linked Analysis Server.
I have already read "Passing Queries from SQL Server to a Linked Analysis
Server" of BOL.
Who has the more information on this features?
Thanks in advance,
Ohjoo Kwon
www.olapforum.com
...
Thu, 13 Jan 2005 02:05:18 +0900
|
Using Search in Discussion
I tried to use the search feature for this discussion group. I put in
"installation" and "Installation" which is in the title and body of the most
recent post. The search was unsuccessful.
Does anyone find this curious? Any suggestions?220 57618 <1CBACAF2-92C2-4C38-91AA-7BAC3E937E34@microsoft.com>
Thread ...
Wed, 12 Jan 2005 08:01:06 -0800
|
Another Analysis Services Installation Problem
We are having a multitude of problems installing AS. When I first tried to
use it I got the "Unable to get list of data mining algorthiums..." and as
recommended we installed service pack 3a.
Now it appears that somehow AS is associated with the profile of the user
that installed the service pack. He ...
Wed, 12 Jan 2005 07:53:03 -0800
|
Analysis Services Installation Problem
Hello,
I have a serious installation problem. My system is Win 2003 with SP1
installed. On the same box I have SQL Server 2000 w/SP3. When I install
Analysis Services with SP3, I receive no error messages. However, I can't
connect to it neither via locally nor remotely. I receive the following
messages ...
Wed, 12 Jan 2005 10:24:14 -0500
|
Processing Virtual cubes
Hi,
I'm using AS 2000 with SP3. I have a dts job that processes my dimensions
and cubes (all full proces)
First all the dimensions. Then the security cubes (i'm using dynamic
security).
Then everytime my data cube and then the virtual cube that combines my
security cubes and the data cube. This works ...
Wed, 12 Jan 2005 07:03:02 -0800
|
Connection problem in a new environment
Hey all
I4ve just created an OLAP cube and a web application that connect just
fine.. I can query the cube and get results and everything. The
environment is a Visual Studio running on a Windows XP and the Analysis
Server running on a Windows 2003 Server.
I have
-- Like ...
Wed, 12 Jan 2005 05:45:17 -0800
|
drill through in cube
I want my users to drill through on the measure cell in
the cube to get the detail info that got that count.
Here is what I did,
In the cube editor i selected the columns that needs to
be seen in the drill through option. When I double click
the cell it shows me the records but those records are
not dis ...
Tue, 11 Jan 2005 09:19:49 -0800
|
Connection Fail...Path no Found
Hi,
When I try to connect to the olap server using the Olap manager tool from my
computer it display this error : On the windows title "Connection Faild" and
then "Path no found"
I already set all permission in the registry.
I searched in the MS site and found nothing.
I'm running Olap service sp3, sq ...
Tue, 11 Jan 2005 12:41:32 -0400
|