Say I have a Client's LIVE Jedox server and have plenty of Groups and Rules with Rights assigned. How do I migrate these cubes to my test server (it's not exact Sync of the LIVE)
- #_ROLE_RIGHT_OBJECT
- #_ROLE_ROLE_PROPERTIES
- #_GROUP_GROUP_PROPERTIES
When I download and upload to my test server I am getting this error
"At least one mapped column must be defined.Dimension 0 has no default write element defined. Use the column menu to assign a column to this dimension.At least one column must be mapped to any of the measures."
Hi Shaan,
I would suggest that instead of exporting/importing these cubes, you go to the test system ETL and create a connection to the System cubes of Prod, create 3 cube connections to these :
- #_ROLE_RIGHT_OBJECT
- #_ROLE_ROLE_PROPERTIES
- #_GROUP_GROUP_PROPERTIES
and try to load it to your test system cubes. That way you will escape OLAP error and have more control over what should be uploaded.
Let me know if this works for you.
@info Thank you for the suggestion. The challenge here is the Live Jedox is on Prem. Sitting in a secure remote machine, Cannot connect to it from outside, I can only export data and FTP to my local environment, Thank you
@shaan007 In that case you can just try to import the file via Connection to Excel and continue with the Integrator. Maybe this helps?
Join the Jedox4Beginners forum and engage with a community of passionate Jedox users. Get expert advice, share insights, and find solutions to your Jedox-related queries. Unlock the power of collaboration and accelerate your learning journey in the world of Jedox.
