I'm trying to generate a Star Schema in Performance Scorecard (version 188.8.131.52) to a relational data base, but when I do that, not all of the data is recorded into the data base (in the HPS_STAR tables). I want the data only into the relational data base, not into an Essbase cube (using Essbase is not an option).
The settings I used to generate the Schema are:
- Calculate For All Dates
Generate Star Schema Rows
- Every Day
Star Schema Structure
- Create with Weights Included
The Star Schema was not generated because there was a size problem with the name of one of the tables it was trying to create. I.e., There was a 'Ñ' as part of the name, and that caused it to be longer thatn the 30 characters limit.