i wang to load data to cube 'Sales' from mysql database using ODBC.
but i get a error "Direct edit dimension collection has not been cleared before commit.". Although the data load was successful, but do not know why the error.
my code is as below:
Code: Select all
<Datasourec> MySQL DB
<prolog> I have clear target cube view
<metadata> i have used dimensionelementinsert function for insert element to dimension first
<data> normally i use cellincrementn function to load data
<epilog> i clear temporary view and subset using }bedrock code and write function CubeSavedata( 'Sales' ); to save the data from memory to disk finally.
Thankyou first.