As discussed previously, PowerOLAP® does provide a method to ensure that a Member you add in PowerOLAP will not be deleted in the Rebuild Metadata operation. This is known as the Mark Member as Persistent feature, and it will be very important to maintain the Members within a Dimension when you Rebuild Metadata, as discussed in the tip below:
Important
The Mark Member as Persistent feature becomes crucial when you add Dimension
Members in PowerOLAP® to those that are "brought over"
by OLAP Exchange® from the source database. For example, you
will almost certainly add Members when you employ PowerOLAP's planning
capabilities—e.g.,
to calculate and compare next year's budget versions versus this year's
actual figures, or for forecasts over the next three months. Actuals
would be brought over from the underlying figures in the source database,
but then you would create, in the PowerOLAP modeler, a Version
dimension, with such Members as Budget1, Budget2, etc or
Forecast1, Forecast 2, etc. You need to keep these "PowerOLAP®-added"
Members "safe" when you Modify Relational Dimension or Process
Cube—so you would
mark each as Persistent, according to the following procedure:
To Mark Member as Persistent, proceed as follows (and here we will suppose that you have not yet performed a Rebuild Metadata for a Cube which contains Juan Guapo Pizzeria2):
1. From the PowerOLAP ribbon, go to Model tab and select the Dimensions command.
2. Select a Dimension, e.g., Customers, then click on the Edit button.
3. Select a Member you want to mark as Persistent, e.g., Juan Guapo Pizzeria2 (which we have assumed to be a new Member after the rebuild), as circled in the following figure.
4. Click on the Mark
Member as Persistent toolbar button, .png)
.
.png)
The number icon that appears beside the Member (a number sign, '#', when it is a Detail Member) will appear with a blue background, indicating that the Member has been marked as Persistent.
Now, when you perform a Process Cube / Rebuild Metadata operation, the Member will continue to exist—it will remain "persistent" in the Cube.
Please see the following sub-topics: