You can usestructures in several different queries. You have to save them in the InfoProvider to reuse them. These structures are then called reusable structures.
When you use a reusable structure in a query, the structure is not copied, but rather the reference to it is.
Changes made to reusable structures affect all queries in which reusable structures are used.
To better distinguish between the two kinds of structures, structures that are not saved as reusable structures are called local structures. Local structures are used in only one query.
You can make local structures from any existing query reusable. Similarly, you can make reusable structures that you use in a query local.
At least one InfoProvider that is filled with data must be available in the BW system.
Creating Reusable Structures
You can copy individual structural components within a structure. This enables you to create similarly structured structural components quickly and easily. For example, if you want to use the formula for a calculated key figure (K1) in another calculated key figure (K2), you can copy K1 and continue to build the formula in K2.
From the context menu of the structural component, choose Copy and from the context menu of the structure, choose Insert. You can also copy structural components using temporary storage locations (Ctrl-C, Ctrl-V).
Making Local Structures Reusable
Using Reusable Structures Locally in a Query
Select the reusable structure in the query and choose Remove Referencein the context menu.
In this way, you use the reusable structure locally in this query. Changes to reusable structures have no effect on the local structure.
In this process, the system changes the ID of the structure and the IDs of the structure elements it contains.
Note that query views, enterprise reports and workbooks that are based on this query reference incorrect IDs after such a change and no longer work correctly. In rare cases parts of Web templates (e.g. a filter command) that reference this structure or its structural components can be affected and no longer work correctly.
We therefore recommend that you make a where-used list for the query before removing the references. In this way you can see its effect on other objects.
The reusable structure is in the structure list of the InfoProvider tree and you can use it again when you create new queries.
More Information: