DML reference - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Analysis Services (2000)

DML reference

Author

Topic

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 2007-09-26 : 08:59:23

Does anyone know of a good DML reference source? I've got to get rid of some hard coded values in the where clause of a DML script and I'm really lost. This ain't T-SQL that's for sure.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-26 : 23:33:35

Then try oracle or ibm.

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 2007-09-27 : 10:43:57

Does oracle or IBM use the same DML as Analysis services?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-28 : 01:17:10

Don't think so. Are you talking about mdx query is AS?

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 2007-10-02 : 11:19:42

I'm not sure what it is, exactly. In DTS it says it is SQL but it looks like MDX. It is running against a cube.

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-10-02 : 14:20:40

Can you post a snippet of what you are seeing to help us direct you?
Here is a multi dimensional expressions reference:

http://msdn2.microsoft.com/en-us/library/ms145506.aspx

Future guru in the making.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-02 : 23:16:14

Looks like mdx since you can't query cube with t-sql.

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 2007-10-08 : 11:39:11

[code]
WITH MEMBER
[Measures].[ItemName]
AS
'[Item Category Lv2].CurrentMember.UniqueName'

SELECT { [Measures].[ItemName],
[Measures].[Sell Through Previous 6],
[Measures].[Sell Through Previous 5],
[Measures].[Sell Through Previous 4],
[Measures].[Sell Through Previous 3],
[Measures].[Sell Through Previous 2],
[Measures].[Sell Through Previous 1],
[Measures].[Open Orders],
[Measures].[Current Need],
[Measures].[Open Order Current %],
[Measures].[Open Order Next 1],
[Measures].[Open Order Next 1 %],
[Measures].[Open Order Next 2],
[Measures].[Open Order Next 2 %]
} ON AXIS(0),

NON EMPTY {
CrossJoin(
Descendants([Distributor Region Lv2].[Region].[North and South America], 2),
Descendants({[Item Category Lv2].[Category].[AA-PRODUCT], [Item Category Lv2].[Category].[AB-PRODUCT]}, 3)
)
} ON AXIS(1)
FROM LOGISTICS
WHERE ([Time].[All Time].[2007].[Quarter 4].[October])
[/code]

At the moment, someone has to manually change the last line before the monthly run starts.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources