Parent-child reference method Generation reference method(using notepad or excel as data source) Make sure the source is ready. A sample file to build geography dimension is as below. The fields are separated By TAB (delimiter). The delimiter can be changed to any other value(explained later)...
Using Excel add- in , we can calculate the Essbase database also . Linked reporting objects(LRO):- LRO are special kind of objects that can be attached to any data cell . we can create LROs from excel add –in or hyperion analyzer , we may another window , where we select attachment...