MDX 帮助和教程
大家好,我再次对 MDX 感到头疼(为什么我的老板认为程序员=解决任何与计算机相关的事情)。
过滤器的尺寸 Productos 是这样组成的 [Casa].[Linea].[Producto],我正在尝试按 Linea 72 和 74 进行过滤,除此之外,有人知道 MDX 的在线教程或书籍吗?
无论如何,到目前为止我的 MDX
SELECT 'Dic 1 2010' AS Fecha, A.*
来自(选择 "[措施].[Piezas Dia]", “[措施]。[P Redondeadas]” FROM openrowset('MSOLAP' ,'数据源=XXX ;初始目录=XXX ;用户ID=XXX;密码=XXX;', '设置[Lineas]为'' 过滤器(后代([产品],[LINEA],SELF),
祖先([产品].当前成员,自我) <> [74 种] 和
祖先([产品].当前成员,自我) <> [72 种] )'' 成员 [Measures].[Piezas Dia] AS ''sum([Lineas],[Measures].[|P| Venta Dia Año Actual])''
成员 [Measures].[P Redondeadas] AS ''sum([Lineas],[Measures].[Venta Piezas Redondeadas])'' 在列上选择 {[Measures].[Piezas Dia], [Measures].[P Redondeadas]} 来自 [文塔·通用] WHERE ([Fecha Diario].[Fecha].&[2010].&[12].&[1])')) as A
感谢您提供的所有帮助。
Hello guys again here with my MDX headaches (why does my boss think programmer = solve anything computer related).
The measure of the Filter
Productos is compose this way [Casa].[Linea].[Producto] and I am trying to filter by Linea 72 and 74, outside this anyone know a good tutorial online or book for MDX?
Anyways here my MDX so far
SELECT 'Dic 1 2010' AS Fecha, A.*
from (SELECT
"[Measures].[Piezas Dia]",
"[Measures].[P Redondeadas]"
FROM openrowset('MSOLAP'
,'DATASOURCE=XXX
;Initial Catalog=XXX
; User Id=XXX;Password=XXX;',
'WITH SET [Lineas] AS ''
FILTER(DESCENDANTS([PRODUCTOS],[LINEA],SELF),
ANCESTOR([PRODUCTOS].CURRENTMEMBER,SELF) <> [74 VARIOS] AND
ANCESTOR([PRODUCTOS].CURRENTMEMBER,SELF) <> [72 VARIOS] )''
Member [Measures].[Piezas Dia] AS ''sum([Lineas],[Measures].[|P| Venta Dia Año Actual])''
Member [Measures].[P Redondeadas] AS ''sum([Lineas],[Measures].[Venta Piezas Redondeadas])''
SELECT {[Measures].[Piezas Dia], [Measures].[P Redondeadas]} on columns
FROM [Venta Gerencial]
WHERE ([Fecha Diario].[Fecha].&[2010].&[12].&[1])')) as A
Thanks for all help provided.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
您可以在此处找到 MDX 的“温和”介绍
You can find an 'gentle' introduction to MDX here
您要求推荐一本书。我的老板刚刚为我购买了 SQL Server 2008 MDX Step by Step。我正在开始浏览它,我喜欢它的布局方式。我已经使用 T-SQL 编程十多年了,MDX 非常接近,以至于让我感到困惑。这本书帮助我以不同的方式思考我的代码和编码实践。我还没有完成它,但我确实认为这对你来说可能是一个很好的开始,因为你可以跳到书中的任何地方来学习你需要知道的内容。
You asked for a book referral. My boss just purchased SQL Server 2008 MDX Step by Step for me. I'm beginning to go through it and I like the way it is laid out. I've been programming in T-SQL for over ten years and MDX is just close enough to confuse me. This book is helping me think different about my code and coding practices. I haven't finished it, but I do think that it might be a good one for you to start with, as you can jump in anywhere in the book to learn what you need to know.
它真的应该是 a 吗?而不是 a ; 此处:
FROM openrowset('MSOLAP' ***,*** 'DATASOURCE=HDZNT10
Should it really be a , instead of a ; here:
FROM openrowset('MSOLAP' ***,*** 'DATASOURCE=HDZNT10