Hi,
i have created a report in report studio.i tried to manually edit sql query in cognos report studio using(generate sql and mdx and then click on validate) validate.i have modified that query.. i enabled cross product allowed in properties to allow cross joins for my purpose.afterr modifying that query if i click ok i am getting the following message :(
"quer data items were not updatd you mustupdate your data item expression manually"
and my query is not holding what are the modifications i did using (generate sql and mdx and then click on validate)validate.its losing modifications and holding old query.its giving the old result instead off new result.
how can i fix this could you please help in this.your help highly appreciated.thanks in advance.
thanks
bvk
hi,
Go to the each and every query in the report where you modified generate sql or mdx or sql override, just drag and drop each data item, then validate it.
siri
Hi siri,
thank you very much for your reply.i have modified query for only one list object.(even i am not modifing just clicking on generate sql or mdx with out doing any modification in sql even that time also its showing the same error)could you please elaborate your answer.so that i can try this.this is very urgent. i am not able to fix it for past 5 days.
other information: after i am clicking on generate sql r mdx automatically my columns names are replacing with alias names in DATA ITEMS tab.
for eg:company alias name is c1
country alias name is c2
after clicking on generate sql or mdx in properties in my data items tab my columns are changing like c1,c2 instead of company and country.
could you please help me to fix this issue.
thanks
bvk
Hi,
I understood, but in this case u can use the sql override from insertable objects pane, copy the generated sql of that query and make necessary changes and assign the override to that query if it is a model driven report.
validate the sql override and save the changes, then update the data items manually...
just drag and drop the data items like country & company in the query to which u assigned the sql override.
it will work try this.....
siri