I cannot update my dimension table in enterprise guide as they keep prompt the error of I not the valid administrators. With this, I cannot change my things.
Is the dimension table created by you?
If yes, do check if you did update your tables at the management console.
If no, you are unable to change, As you not given the rights to update other tables, other than you ones that you created.
Could it be that you actually imported someone else queried-done (sorry idk whats the right word to use xD ) table into your ETL ?
I did it accidentally before hence causing some administrator-sorta of error :(
Especially tables like Customer and Employment since most of us uses them and the same table . We may not be able to use our other group member's data .