The sentence “Is it not a great idea?” is interrogative. To change it into the assertive form, we remove the question structure and express it as a statement. It is a great idea. What a great idea it is! → This is exclamatory, not assertive.
It is not a great idea. → This changes the meaning (negative).
It was a great idea. → This changes the tense (past).