|
Query crashes olap services
I've got an ODD problem and I'm looking for some ideas as to where to
look next for a solution.
I have a dot net app that queries a cube using adomd.net. I use 3 basic
queries depending on what the user selects on the web page. 2 of the 3
queries work fine, the 3rd crashes the olap service and puts the
f ...
Fri, 14 Jan 2005 11:51:18 -0600
|
Fact Table Population ...
Hi All,
Can any one give me an idea in how to plan the popluation of Fact Table
in a ware house ?.
...
14 Jan 2005 07:13:59 -0800
|
MDX Time Average
My time dimension has levels going through from year down to hour
(Y,Q,M,D,H). At day level I have a property which specifies the days full
name as apos it's position in the month. Let's say I have a measure called
[Calls Received].
What would be the best approach to calculating the average number of calls ...
Fri, 14 Jan 2005 06:17:03 -0800
|
Analysis Services and firewall
I've a server with sql 2000 sp3, analysis services sp3 and iis6. On that
server i've created an asp website linked to the cubes with pivot table 10
From a client NT4 i try to browse the site but the pivot table return
"unable to connect to server"
Maybe the problem is the firewall. Which ports do i have t ...
Fri, 14 Jan 2005 04:01:02 -0800
|
Create a Set using TopCount and Filter on Member Property
Hello All,
Please may I have your assistance on the following::
set [TOP SERVERS2] as
'TopCount(Filter([DeviceA].[Device Name].Members,Val(DeviceA.CurrentMember.Properties("is Server"))=-1), 10,( [Measures].[bytes],
[Time_month].[01/01/2005]))'
I'm trying to return the top 10 DeviceA members based on the ...
Fri, 14 Jan 2005 11:59:38 GMT
|
change datasource Name of olap database
How can I change the NAME of a datasource within the olap database.
To change connections to the database is not the problem, but the NAME of
the connections you cannot change, nomally.
I don't want to edit Cab files, I want a solid solution.
Who can Help me
--
Nico 't Hoen ...
Fri, 14 Jan 2005 03:35:01 -0800
|
Currency Problem
Hi,
I have a cube and have created a lookup cube to get currency rate. I
have a calculated member that does a lookup from the main cube to get
the rate from currency cube based on currency selected and year
selection. This works fine.
I also have a currency dimension (USD,GBP,EUR) where GBP is the native ...
14 Jan 2005 02:21:52 -0800
|
Possible to return 0 instead of blank?
Is it possible to have an mdx query return 0 instead of blank? I have a lot
of measures that are numeric, so is it possible to add some statement to the
query og something to get a 0?
Kaisa M. Lindahl
...
Fri, 14 Jan 2005 09:28:08 +0100
|
aggregation at higher levels with differing vlaues (percent & count)
Currently we have a dimension which has following levels
Level 1
member 1
member 2
member 3
Level 2
member 4
member 5
member 6
the dimension table structure is
PSSID Mgroup MDetail
Mgroup will have Level1 and Level2
Mdeatil will have the member1,member2 ....member 6
member 3 and membe ...
13 Jan 2005 20:51:29 -0800
|
"ALL" level seems incorrect in BI Accelerator1.2
I am using BI Acclerator 1.2 and there seems to be a problem with the way the
"ALL" level works with the auto-created calculated members.
When selecting ALL, the calculated members, such as YTD, Current Year, etc.
are also rolled into the total; creating a summed value that is 6X larger
than it should be. ...
Thu, 13 Jan 2005 10:45:07 -0800
|
Cluster Install KB308023
In the above article one assumtion states "The cluster group in which you
configure AS always runs on the same node as the default cluster group, wich
contains the clister IP and cluster name"
Question - Is this statement referring to the Win2K3 Cluster IP and Name or
the SQL Cluster IP and Name?
Thanks ...
Thu, 13 Jan 2005 09:23:03 -0800
|
Error when processing
Internal error: Object does not exist 60
Any clue ?
when validating cube structure there is no problem and it processed a few
hous without trouble and NO changes have been made to the
AS structure...??
/Michael V.
...
Thu, 13 Jan 2005 17:44:52 +0100
|
MDX Help using probably a combination of TopCount, Sum and Rank
Please may I have your assistance with the following
My Analysis Server Db design is as follows
Cube Name: Server_day
with a source table filter
"OLAPDeviceA"."isServer"=1 or "OLAPDeviceB"."isServer"=1
hence from the following dimensions DeviceA or DeviceB is a Server
Dimensions::
Time_day
Devi ...
Thu, 13 Jan 2005 16:10:16 GMT
|
Different value in the "Total"
Hey
I am just wondering whether it is possible to display a different value
in the Total value then the aggregation will produce.
Let me try to explane..
for example.. I have a Time dimension that has this layout
YEAR MONTH DAY
-All Time All Time Total
...
Thu, 13 Jan 2005 08:09:18 -0800
|
Help with 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:25:48 -0500
|