how to get max min date from a tuple

greg lipman 61 Reputation points
2024-09-19T10:53:17.7133333+00:00

suppose i have a bunch of people (with dimension) they have a bunch of claims (dimension)

and in each claim there is a bunch of records with amount and date!

those records/transactions form a cube with measures like amounts paid

Ultimately i need to get the average time between first and last payments (claim trail length)

for each person (adjuster)

but I cannot even get to extract the first (min) and last (max) transaction date for each person/claim set

with member LastDate as

!!!!! max date with the highest key perhaps???

but need to get inside tupe of person/claim

SELECT

{MEASURES.[LastDate]}

ON 0,

     ([Person].[Hierarchy].[Person Name].members, 

	 [Claims].[ID].members),

ON 1

FROM [mycube]

Thanks!!!!

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,278 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.