This content has been marked as final. Show 4 replies
Why don't you map to a view?
Create a view that contains data from both tables and map to it instead. Use joins or unions to get the data to look exactly how you want it. This will also give you the ability to change the view definition whenever you want without having to re-map the cube. I'd recommend always mapping to views anyway just for the flexibility that it gives you.
i even tried mapping to view. First time,i populated the cube with the view having first day data. but when i try populating the cube with the view being changed to have second day data,am getting the below error.
"INI: error creating a definition manager, Generic at TxsOqConnection::generic<BuildProcess>INI: XOQ-01724: invalid USING clause, Generic at TxsOqBuildProcessor::initializeForDimension"
So am not able to populate the cube when the data in the view has been changed.any idea on this why am i getting this error????