Date Hierarchy

[former_member809077]

HI,

Please, is it possible to add only a "DAY" hierarchy in date?

[former_member809077]

sorry for all the questions. i just started using the software.

please, Is it possible to calculate percentiles (50th, 70th, 90th) in SAC. Because i cant find the function anywhere.

[Sowmiya_C]

margaret kalu,

Meaning you want to find date difference between two days?

[former_member809077]

yes.

But the datediff function is not in my calculated measures.

Any response about the percentile calculation ?

[Sowmiya_C]

Hi margaret2,

If you need Day as a separate column. Please try this workaround.

Let me know if it works for you!

Thanks,

Sowmiya

[former_member809077]

Thank you... i choose flat presentation in the Hierarchy and it displayed the specific day. Thank you.

DATEDIFF function for finding date differences --- can the function be used on a table analysis or only in the raw model.

couldn't find the function in the "calculated measure" when i tried creating a table analysis

[shraddha_mundwadkar]

Hi ,

Can you please give more details, what do you mean by a Day hierarchy? Below hierarchies are possible for a Date.

Thanks,

Shraddha