logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
sealfan  
#1 Posted : Friday, September 11, 2015 4:33:49 PM(UTC)
sealfan

Rank: Member

Groups: Registered
Joined: 9/4/2015(UTC)
Posts: 23
Canada
Location: ottawa

Thanks: 7 times
Was thanked: 2 time(s) in 2 post(s)
I would like to restrict (filter) a query based on user selected values. However, instead of typing the values (and the error that comes with typos) I want the selection list to be based on a Dimension Table in the DB.

I see that in the Dashboard Sales you have a restriction based on a selection list. However, I do not see how I can get that into my report as for my restrictions I only have 4 strings I can enter into the Model.

Is there a way to get the same restriction selection you have in Dashboard Sales and have that selection based on a Dimension Table query (Select column from table)?

What are your thoughts?
sealfan  
#2 Posted : Friday, September 11, 2015 5:45:50 PM(UTC)
sealfan

Rank: Member

Groups: Registered
Joined: 9/4/2015(UTC)
Posts: 23
Canada
Location: ottawa

Thanks: 7 times
Was thanked: 2 time(s) in 2 post(s)
Got it. Enums are the way to do this.
sealfan  
#3 Posted : Monday, September 14, 2015 1:19:24 AM(UTC)
sealfan

Rank: Member

Groups: Registered
Joined: 9/4/2015(UTC)
Posts: 23
Canada
Location: ottawa

Thanks: 7 times
Was thanked: 2 time(s) in 2 post(s)
To Elaborate. If you browse your data source, expanding tables and then expanding Columns By Category, expanding your Dimension Table and select your column you want to filter on, there is an option to "Create enumerated list from this column. Select this option. That will create a list based on a SQL query to this dimension table selecting all values from this column.

Then if you drag this column into your report you will see that the restrictions are now populated with the column values from the DB.
thanks 1 user thanked sealfan for this useful post.
epf on 9/14/2015(UTC)
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.