Can you please check if a reference to the tables is missing in definition of the objects.Do you have contexts in the universe?Is it happening with any other object? Please try to make the query as small as you can, with the error just in it. Sometim...
You can use this formula in order to change the value on each refresh: variable = If(Mod(ToNumber(FormatDate(CurrentDate();"ss"));2) = 0;"Hello"; If(Mod(ToNumber(FormatDate(CurrentDate();"ss"));2) = 1;"Bonjour"; "Hola"))
Antonette is right, before you can use a calendar it must be created as it was described by her. If Calendars already exist in your system and you can't use them you need some administrator, who gives you view rights on those calendars.
Basically you want one row to be spitted up into two rows. I don't think that this can done. Two row into one that is possible via aggregetion but not vice versa.