cancel
Showing results for 
Search instead for 
Did you mean: 

Date Dimension in SAC

Vasu_Sac
Explorer
0 Kudos

Hi 

I am using Date dimension in my model with display Fiscal year / Month hierarchy in stories I am trying to configure to select only one month by user.  If I configure single selection, its not showing all dimension values to select required month by user. It is showing just one dimension value on design mode and it is showing same value at view mode but not showing all dimension values to change or select other value.

I tried to show unbook members and other ways but unable to show all dimension values with single selection (Radio button). 

It is working for multiple selections (all dimension values are appearing if it configure 'Multiple selections').

Is some thing missing to show as required. any advise please.

Regards

Vasu 

 

View Entire Topic
N1kh1l
Active Contributor
0 Kudos

@Vasu_Sac 

You need to provide all months as selection by selecting them in the filter for date and set it to single selection.

N1kh1l_0-1708841227755.png

Date Filter

N1kh1l_1-1708841265048.png

Br.

Nikhil

Vasu_Sac
Explorer
0 Kudos
Thanks @N1kh1l . Yes, it is appearing now other date dimension members once moved to all leaf nodes to ‘Selected members’. Now this is flat structure and user should search to select the required member. Is it possible to show hierarchy structure for single selection. Example Year 2024 under all 12 months with single selection. Regards, Vasu