我如何将此 SQL 查询转换为 MDX？

发布于 2024-12-11 21:11:49 字数 340 浏览 0 评论 0原文

我搜索了不同的 MDX 资源并阅读了大量有关 MDX 选择和过滤器的材料。我有一个必须在 MDX 中重构的 SQL 查询：

Select Left (hcc_key, 2) as Rayon
From [alias_dat].[dbo].[tbl_dim_responsible]
where usr_name=('John Doe')

How do i select a name field from a table in MDX using the Left Function?

我知道MDX与SQL完全不同，因此不能完全翻译。如果有人可以帮助我更进一步，我将非常感激。

原文

I have searched different MDX resources and read a lot of materail about MDX selects and filters.
I have this SQL Query that I have to restructure in MDX:

Select Left (hcc_key, 2) as Rayon
From [alias_dat].[dbo].[tbl_dim_responsible]
where usr_name=('John Doe')

How do i select a name field from a table in MDX using the Left Function?

I understand that MDX is completely different to SQL and thus can't completely be translated. If someone could help me get a step further, i would be very grateful.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

把人绕傻吧 2024-12-18 21:11:50

试试这个：

With
Member [Measures].[Rayon] As Left([Dimension].[Hierarchy].CurrentMember.Name, 2)
Select
{[Measures].[Rayon]} On Columns,
{[Dimension].[Hierarchy].[Level].Members} On Rows 
From [Your Cube]

Try this one:

With
Member [Measures].[Rayon] As Left([Dimension].[Hierarchy].CurrentMember.Name, 2)
Select
{[Measures].[Rayon]} On Columns,
{[Dimension].[Hierarchy].[Level].Members} On Rows 
From [Your Cube]

回复收藏 0 原文

~没有更多了~