Create views for Workbook

[Former Member]

Hello,

I need to create a workbook which has the same row and key figures but each tab should have different countries.

a. Should I create three different queries restricting each query to the country I need to display

or

b. Can I create different views out of the same query?

- If so, how can I create query views and insert them into my workbook.

Taking performance into consideration, which method is the best.

All feedback is appreciated with points:)

Thanks for your help.

Please send your comments

[Former Member · Accepted solution]

creating three different queries is a better option.

View is a navigational state of the query and when you do not need all the data, it makes no sense to get all the data from the infoprovider and then restrict it.

[Former Member · Accepted solution]

Hi,

How about restricting the same query with different countries at the workbook level and saving?

Best Regards,

Hima

[Former Member · Accepted solution]

Sorry. that is what I meant also. Insert the same query three times and restrict at workbook level.

[Former Member · Accepted solution]

Thanks a million for your responses.

But how can I restrict my query on the workbook level. Can you please walk me through this.

Thanks!!!

[Former Member · Accepted solution]

go to the query on each tab and on the characteristic select filter value and assign corresponding value and save.

[Former Member · Accepted solution]

Thanks for the points.