BookmarkSubscribeRSS Feed
LukeL
Obsidian | Level 7

Hi all.

I have a simple question for you Smiley LOL

We would need to create a percentile measure in an olap cube. As far as know, the measure is not available as a predefined aggregation, but...is there a way to obtain it, maybe via mdx or via information map? The problem is that this kind of measures, as a nunique, would rely on all the original dataset, and cannot be preaggregate...

I have tried by making a calculated mesure by making a key dimension for each row, and calculating the measure as

pctl5(90, SetToList({[KeyDimension].CurrentMember.Children},[Measures].[MeasureToUse])),

where measure to use use a mean aggregate function (but going to keyDimension I would have the mean of every single value, so the value itself).

but the response is:

Insufficient memory - in the "CHILDREN" function

 

Has anyone any feasible solution?

 

Thanks! 🙂

1 REPLY 1
AnnaBrown
Community Manager

Hi LukeL,

 

You might want to open a track with Technical Support for that “insufficient memory” message. There may be some options or a different syntax that might work for this exercise.

 

Best,

Anna

 

 

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1027 views
  • 0 likes
  • 2 in conversation