If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

error while editing query in cognos report studio?

Started by bvk.cognoise, 08 Sep 2011 10:53:18 AM

Previous topic - Next topic

bvk.cognoise

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
Regards
BVK

siri

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

bvk.cognoise

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
Regards
BVK

siri

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