Extended Analytics export

Hi FrankDK 

Here are some ideas in the form of an outline of the steps needed to create an "extended analytics" star schema like HFM has 🙂  :

1. Choose the dimensions you wish to use in the star schema
2. Create a fact table with columns:
   
   1. (1) column for each exported dimension's member IDs
   2. (12) data columns, one for each period
3. Create a dimension table for each exported dimension.  The ID column in each dimension table is PK, tied to the dimension column in the fact table. This is the "star", dimensions at the points and facts in the center
4. Choose a default member from each dim not exported to use in the member script, I'm thinking export with FDX
   1. Create a buffer to hold the fact data as a MemberInfo from each dim associated with each data value.
5. Export the Dimensions to the dimension tables
6. Using the buffer, export the data by member id for each dimension into the fact table.

Viola!  you have an extended analytics star schema for BI analysis.  I think everything here can be coded in an Extender Rule.