|
SQL Server Edition Upgrade
Hi
I have just developed a large OLAP database using Developer Edition. Few
weeks ago we purchased the SQL Server Enterprise Edition. Do I need to
upgrade the Developer Edition to Enterprise Edition? Or now that we have the
license, we don't need to as the Dev edition is a full feature edition? If I
hav ...
Fri, 3 Dec 2004 10:35:10 -0800
|
Problem accessing cubes over web using data pump with msolap.asp / msmdpump.dll (solved)
Hello,
I am posting this in case somebody finds this information useful. I
did not come across this solution anywhere, so it might help somebody
out there.
We had the following situation:
- Access to the cubes using the Microsoft PivotTable component in a
web page.
- A W2k3 IIS 6.0 box, using msolap.a ...
3 Dec 2004 03:38:34 -0800
|
How to calculate OnHand values (non-aditive measures)
Hello,
I suppose that for some of you is a very known problem, but it gave me
troubles...
I have a fact table with stock variations by date, product, store. That fact
table has 1 measure: Qty.
On another table I have the history of Unit price, by store, product & From
date / To Date.
In the cube I have a ...
Fri, 3 Dec 2004 03:51:57 -0500
|
To display measures between two dates
How to write a query to filter data between two dates.i.e
Suppose i want to find the sales of a person from 2nd march 2004 to
3rd october 2004.
i.e in short what can i write in mdx in place of 'between' in SQL. ...
2 Dec 2004 23:25:23 -0800
|
MDx syntax to calculated quarter value as nonempty month value in
Hi All,
I am new to MDX .We need to measure driver count against time.
Measure level
Driver Count
Year All time 12
1920
....
2003
q1 Quarter 1 total 5
...
Thu, 2 Dec 2004 19:53:03 -0800
|
MDX Syntax
Hi everyone:
I have the following MDX query:
SELECT [Parts].Children ON ROWS, [Rank].Children ON COLUMNS FROM
[mycube]
Lets assume the following grid is displayed by the Analysis Services
MDX Sample Application:
|---------------|---------|--------|
| | 0 | 1 |
|---------- ...
Thu, 02 Dec 2004 11:40:50 -0800
|
MDX equivalent to SQL's IN operator
Does MDX have an equivalent to sql's IN operator?
Here's my code:
MEMBER [d_MarketProvider].[M Total] AS
'Sum(
Filter(
[D_MarketProvider].[Market Name].Members,
[D_MarketProvider].CurrentMember.Properties("Market ID") = "1" or
[D_MarketProvider].CurrentMember.Properties("Market ID") = "6" or
[ ...
2 Dec 2004 11:32:24 -0800
|
Make BIT column say somthing other than True/False
I am hoping for a quick answer since I have to go live on this today!
;-)
Is it possible for a column to say something other than true/false for
bit columns? I have a dimension in a report called "Active" that is
pulled from a BIT column in a SQL db.
In my OLAP report (viewed in a OWC PivotTable) instead ...
2 Dec 2004 09:20:40 -0800
|
using a member property in a calculated measure
My question has two parts. The below situation would be equivalent to my real
world scenario.
1. In the FoodMart 2000 database, I would like to calculate sales/square
foot (of store size).
2. I only want to calculate this value for some dimensions (ie I don't want
sales/square foot for each product or fo ...
Thu, 2 Dec 2004 06:11:04 -0800
|
MDX: Union of slices
I would like to slice on 2 dimensions in the following way:
In the sales cube in the sample OLAP database I need to retrieve the
Unit Sales for Gender=Male OR Marital Status=Married. This mean I am
looking for the measure on the UNION.
Somebody suggested, I do this:
with member measures.mm as
'sum( union( { ...
2 Dec 2004 06:10:38 -0800
|
create global cube
I am using 'Create Global Cube' to create local cubes successfully.
create global cube SolaAO storage
'e:\solaao\reps_cubes_databases\derek_waine\solaao.cub' from [SolaAO]
(measure solaao.Contribution, measure solaao.[Net Value], measure
solaao.[Quantity Pieces],
measure solaao.[Qty Coating Pieces], ...
Thu, 2 Dec 2004 10:46:54 -0000
|
Error locating cube'cubeName' on connection
Hi,
The above is an error I received after processing a cube. I can see that
the cube is processed and browse data in the cube editor but in the data
pane of Analysis Manager I receive an error. The cube is not visable to
other applications. I have now processed the cube (and rebuilt all
dimensions) 3 time ...
Thu, 2 Dec 2004 09:17:04 +0100
|
getting data from analysis services through adomd.net
Can anybody tell me the adomd.net newsgroup address? Thanks ...
Wed, 1 Dec 2004 23:49:05 -0800
|
The Data Miner: SQL Server Data Mining Newsletter (December 2004)
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0139_01C4D7FD.19603650"
------=_NextPart_001_0139_01C4D7FD.19603650
...
Wed, 1 Dec 2004 23:25:52 -0800
|
Semi Additive Measure Problem
Hi,
I have current balance that get updated once every month and we show the
latest balance as of a given month to the users. I have a simple formula:
If I am at all time level, I need to use the time default member, which is
set to be the latest month in the cube dynamically.
iif(([Time].CurrentMembe ...
Wed, 1 Dec 2004 10:21:08 -0800
|