Recent content by synchronoss

Dear Friends, Please help me in designing a solution for the following: I need to send a quick snapshot of information (summarized) to all our Executives using Notice Cast. The information which needs to be sent is stored in a summary table. I just need to have a SQL that reads this summary...

Hello VTJ, I have done similar kind of work in my last project. You can avoid users to enter their logon information to access Reporting through application by using a simple technique. The java program (JSP web page) in my case redirects to the Cognos upfront address with cognos role. The...

Dear Friends, I'm stuck in middle of troubleshooting a critical production issue. I'm trying to take snapshot of Production environment by moving the entire Production environment to UAT environment. I'm using CQPack utility to pack the whole of CQ Data Store on Production including export of...

Guys! I'm facing a wierd problem. I'm using Cognos Query 6.2 where it has Personal NewsBox for customers inorder for them to save their own queries and reports. Now when I log in as an administrator i can see Personal NewsBox for all customers. But when customer logs in with using their own...

sln007 Thanks! I tried with both filters. The first one throws error as follows (today() - 001 00:00:00.000) = "Up and Billable Date") Syntax error near "0" at line 1. The second one works fine but i dont see any data in my report as all data gets filtered when i execute...

sln007 Thanks! i guess it should work but i have a worry. Since i'm working on Cognos Upfront there is no option of ASSOCIATE to associate calculated column to grouped item. How should i do this in Cognos Upfront Appreciate ur response! Thanks Pradeep

Hi Everyone! I have a query which needs to be implemented immediately. I have a report which has a column called Up and Billable Date. This column contains dates for Up and Billable Orders. Now i need to have a query based on this column that will show report with orders that have become Up and...

Dave Thanks a ton for ur suggestion. The customer got back to me with requirement slightly changed with previous one. The customer now needs to have duplicates grouped together in the same report. They dont want to have another report as i mentioned earlier How can we do this? I would...

Guys pls help me! I have a report in Cognos Query that shows records with duplicates. The customer wants to see another report based on this report that shows all duplicates grouped together. This needs to be done on Cognos Upfront. Can anyone assist me in doing this? Thanks Pradeep

J There is a way to schedule building of cubes automatically. I have written a macro that would perform this job. This macro will even read all the cubes by opening the Cubes folder and pick each cube in the folder and start building them. Also this macro logs the process showing complete...

Hi, Can anyone suggest me if there is any possibility of automatically scheduling the built cubes into Powerplay Enterprise Server. Is there any ready Cognos scripts available to do this job? Appreciate your responses! Thanks Pradeep