如何在 MS Analysis Service 中显示列的最后一个值？

发布于 2024-08-08 04:34:00 字数 209 浏览 10 评论 0原文

我有一个具有多个维度的立方体。我需要（测量、计算等......）来显示列的最后一个值，假设该表按另一列排序。

像这样的东西：

SELECT TOP 1 column_1
FROM table_1 
WHERE «The user's selected dimentions will work as a filter»
ORDER BY column_2 DESC

原文

I have a cube with several dimensions. I need (a measure, calculation, whatever...) to show last value of a column, assuming the table is sorted by another column.

Something like:

SELECT TOP 1 column_1
FROM table_1 
WHERE «The user's selected dimentions will work as a filter»
ORDER BY column_2 DESC

分享到QQ

分享到微博

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

发布评论

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

泡沫很甜 2024-08-15 04:34:00

您可能会使用类似的

WITH Measures.[Top 1] AS
     TopCount([Dimension1Name].[Attribute1Name].[Level1Name].Members, 1, [Dimension2Name].[Attribute2Name].[Level2Name].Members)
SELECT Measures.[Top 1] ON COLUMNS
  FROM [CubeName]

名称，其中带有 1 的名称引用您的 column_1，带有 2 的名称引用您的 column_2。

You would possibly use something like

WITH Measures.[Top 1] AS
     TopCount([Dimension1Name].[Attribute1Name].[Level1Name].Members, 1, [Dimension2Name].[Attribute2Name].[Level2Name].Members)
SELECT Measures.[Top 1] ON COLUMNS
  FROM [CubeName]

where the names with 1 refer to your column_1, and those with 2 to your column_2.

回复收藏 0 原文

~没有更多了~