In order to give you more specific advice, I would need to know what exactly you mean by "past week's data" (e.g., "one week prior to the current date and time", or "one week ending at EOB yesterday", or "last week's data") and what restrictions you are encountering using the GetDate() function. If none of them give you exactly what you need you can implement your own custom function aliases (note that you can call other function aliases from your unction alias, and thereby leverage existing FAs).
If you are talking about pulling the past week's data from the materialized view once it is populated, you may be able to set the query limits using some of the OOTB date/time function aliases or combinations thereof. Obviously it’s faster and more efficient. Microsoft SQL Server differs from other RDBMS by the way of implementing materialized view via a concept known as 'Indexed Views'. It is under the control of your DB administrator. When you create the indexed view, SQL Server materializes the data in the view into physical table so instead of doing complex joins, aggregates, etc, it can queries the data from that materialized table. The query to populate the view is external to Pega. Views cannot be created on Temporary Tables. Cannot use an Order By clause with views without specifying FOR XML or TOP. These limitations include: You cannot pass parameters to SQL Server views.
The SET options in the following table must be set to the values shown in the Required Value column whenever the following conditions occur: The view and subsequent indexes on the view are created. However there are certain limitations for SQL Server views. To make sure that the views can be maintained correctly and return consistent results, indexed views require fixed values for several SET options.
Are you asking about the query that populates the materialized view, or the query to retrieve data from the materialized view once it is populated? Views provide an abstraction layer to underlying data, simplifying data access. Robotic Process Automation Design Patterns