ADVERTISEMENT

Running Cognos From SQL

Jul 23, 2005

Is it possible to exec a Cognos report from a SQL job?--Message posted via http://www.sqlmonster.com

View 1 Replies View Related

Cognos IWR Server

Jul 20, 2005

Our disk drive died, and we were able to backup most of the files (allthe reports, the shuttled, pending, etc)But when we open the administrator, we get a blank. none of ourcatalogues are listed in there.I don't want to recreate all the catalogues and reports- does anyoneknow how we can "import" them in there? The database that contains allthe "data" was not backed up, sicne it was in use during backup (badNetwork admin)If anyone can help, PLEASE email. trying to get an answer from cognos,but who knows?!!!

View 2 Replies View Related

Cognos Cube

Oct 25, 2007

Is it possible for RS to connect to a Cognos cube?

If so, where can I find information on it especially how security within cognos is evaluated/verified.

View 2 Replies View Related

Cognos Vs SSIS

Nov 27, 2006

We are trying to investigate the ETL tools available in the market and have narrowed down to two

COGNOS - ETL (Data Manager Tool)

Microsoft - SSIS

Is there a comparison study out there which would help us in this process. Also a list of things we need to look out for in a ETL tool will also help.

Thanks

View 1 Replies View Related

Cognos Controller 8.2 Prob

Jan 25, 2008

Hi

I have an installation of Cognos Controller 8.2. The installation of application seems to be all 100%.I can create blank SQL database use the application to upgrade the tables but as soon as I populate the database with data and try to optimise from the application there is an issue. It gives me the error below:
Standard error
Number 5
Source: Frango dircect.Optimise.DeleteTempFox#controllerProxyClie nt
Description: System.Web.Services.Protocols.SoapException
server was unable to process request-->System.Security.Security Exception: Permission Denied
I have checked permissions on the database and all is fine "fastnet" is added as the DB owner and the SQL instance is 100%, Can anyone please shed some light on this.

View 3 Replies View Related

Migrating Cognos DM ETL To SSIS?

May 29, 2008

Hi all - just wondering if anyone could give me an idea of how arduous this task would be (migrating Cognos Data Manager scripts to SSIS). I realize it wont be a trivial endeavour, but wondered how much of a headstart having the initial validated Cognos catalog would be to this project (or would it be pretty much useless?)

Thanks

View 4 Replies View Related

SqlServer(2005) Driver For Cognos

Jan 17, 2008

Hi,
We are having performance issue (too slow) compiling cubes utilizing Cognos over SqlServer database. The driver used is Microsoft Sql Server (OLE DB). Is that the right driver to be used?
Any idea what could be the problem?

Thanks

View 2 Replies View Related

Cognos Measure Allocation / Scope In MSAS

May 5, 2005

I am a Cognos developer (10 years) and am frustrated with the apparent lack of MSAS ability to replicate Cognos measure scope / allocation features.

I have built three cubes, Sales Info, Store Count, and Date Count and wrapped these into a virtual cube (Sales Reporting). Both the Store Count and Date Count cubes have just a single dimension and a single measure each (Distinct counts of Stores and of Days respectively), this is my attempt at replicating the use of several fact queries with differing scope in Cognos Transformer. In my virtual cube I wish the distinct counts to be allocated constantly within dimensions that are out of scope. For instance if I have product categories as rows and my measures as columns then I wish to see the total number of stores on each row and the number of days in the date range so that I can calculate a few ratio's. I do not wish to see the number of stores that sold products in each category or the number of days products in that category were sold, which is what I see if I use distinct count measures in a cube with the exact same dimensionality.


All that I have been able to achieve is something similar to Cognos's 'do not allocate', zero's appear down the list of categories in out of scope dimensions.

TIA

View 4 Replies View Related

Any Tool To Convert Cognos Reports To SSRS?

Apr 19, 2007

Hi. We've got hundreds of Cognos reports and catalogs and we'd like to convert them to SSRS reports and models. Is there a tool to do this? We're converting our reporting to SSRS and need help. Thanks.

View 2 Replies View Related

Crosstab Alternate Hierarchies Of An MSAS Cube Using Cognos

May 5, 2005

Good day all

I am unable to crosstab different alternate hierarchies of an MSAS cube from a single dimension, I'm using Cognos Powerplay (7.3 web and client) to browse the data. v 7.1 displays the same behaviour.

When I try to create the crosstab the display replaces both rows and columns to the alternate path, it overwrites the original path. Can anyone tell me if this is a Cognos issue or an Analysis services one and if there is any way around it. The only solution I have at the moment is to bodge it by creating seperate dimensions for each alternate hierarchy however this is ugly and difficult to use.

Regards
Mike

View 7 Replies View Related

Comparison Of SQL Server Reporting Services To Access Reports, Crystal Reports, Cognos Or Other Options

Nov 5, 2007

Hello SQL Server Experts, Data Analysts, and Report Writers et al:

re: Reporting Options with SQL Server

I wanted to propose an offshoot to the pryor thread:

Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?

I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?

Thank you to all, and I hope this is a beneficial discussion to others.

Hal1490



Hal9000

View 4 Replies View Related

Please Help Migration

Jan 26, 2005

I have developed a database on my local machine using MSDE. I am using Visual Studio.net to add tables/stored procedures to the database. I have created asp.net pages. I need to get this database on a web server that runs Enterprise SQL Server. Can I just use the 'sp_detach_db' and 'sp_attach_db' to move the database between servers?

View 4 Replies View Related

Migration

Aug 29, 2001

Hi Everyone,
I am migrating my old sql server database to the new hardware, in the processes I migrated all the databases from old sql server 7.0 to new sql server 7.0, and also generated the scripts for all jobs and executed in the new server, all the jobs appear but when I go and see in the job steps, I don't see any steps in the jobs, I tried different ways but I am not able to get the steps.
Can any one help me out..............
I have about 160 jobs so I cannot make new steps for each and every job.

Thanks in advance.........

Regards,
Madhuker.

View 1 Replies View Related

Migration

Aug 30, 2001

Hi Everyone,
I am migrating my old sql server database to the new hardware, in the processes I migrated all the databases from old sql server 7.0(All tables from MSDB Database, sysjobs, syshistory etc) to new sql server 7.0, and also generated the scripts for all jobs and executed in the new server, all the jobs appear but when I go and see in the job steps, I don't see any steps in the jobs, I tried different ways but I am not able to get the steps.
Can any one help me out..............
I have about 160 jobs so I cannot make new steps for each and every job.

Thanks in advance.........

Regards,
Madhuker.

View 2 Replies View Related

Migration

Sep 20, 2001

I want to do a data transfer but i am not sure how ..from oracle to sql server.

i want to know if its required to install the oracle client to configure so as to transfer data or not.

I heard from someone that if we change the win.ini file entry for oracle.ini and place the tnsnames.ora file i spcified location it will work but it does not what is the way to deal with..


How do i perform this with the odbc configuration for oracle..and use the same in the dts.

Thanks in advance.

View 1 Replies View Related

Migration 6.5 To 7.0

May 9, 2000

Hi Every one,
I am upgrading from one computer to another.
I have few questions.

1. Is it neccessary to run the SQL Services on Domain User Account on both machines or on 6.5 machine.
2. How to check the all User logins exists in Master database.(I read in BOL that all user logins must exists in Master Database)
3. How much time it will take to complete for 10 GB database.

Please give me anohter suggetion which will help in this regard.

Thanks,

Dindu.

View 1 Replies View Related

Migration

Aug 28, 2000

Can any one tell me the steps to migrate sql server 7.0 from one server to another server(Production databases). Its a 24x7 shop. The down time should be minimal. Iam looking for a most efficient way of doing that.

View 1 Replies View Related

Migration

Feb 19, 2001

Is it possible to migrate SQL Server 6.5 to 2000? We have an ACtive/Active Cluster Environment. It it's possible, please give me a brief guidance on how to go about it. Thanks for your help.

View 1 Replies View Related

Sql 6.5 To 7.0 Migration

Aug 11, 1999

has anyone migrated a ms sql 6.5 server to a mssql server 7.0
on 2 different machines? and if so how the heck didja do it?
the 7.0 server keeps telling me that it cant do it until the 6.5 server
is upgraded.....help...help....help....the 7.0 server has the 6.5 one registered it just wont connect to it....tells me that it has to be a 7.0 server.....help


thanks

tony

View 1 Replies View Related

Migration

Jan 28, 2002

What are the differneces between using Backup/Restore vs Copy Database Wizard when Migrating a SQL Server 7.0 Database to SQL Server 2000 ?

View 2 Replies View Related

Migration

Apr 9, 2001

I have to migrate INFORMIX database to SQL Server 7.0 and I was wondering if there is anyone out there with any experience? I want to know the procedures and how to go about it towards a successfully INFORMIX migration to SQL Server. I look forward to hearing from you.

Regards,

View 1 Replies View Related

Migration To Ms-sql

Jul 6, 2004

Hi,

Does any one aware of any tool for sybase to ms-sql migration, which will migrate store procedures/triggers from sybase to ms-sql server 2000.

Thanks
Vaishali

View 3 Replies View Related

Migration

Aug 14, 2004

Dear Experts

Can any one please help me in MIGRATION of table from Foxpro 2.5 and MSVisualFoxpro 6 to MSSqlServer 2000


I had a large no of table in foxpro now i want all of them in SQL SERVER 2000


Thanks and Regards

View 2 Replies View Related

Sql 7.0 To Sql 2K Migration

Apr 1, 2004

Hi There,
Greetings! Many of my clients are on SQL 7.0 (Win NT) and want to upgrade to SQL2K (Win 2003). We have approximately 1200 Stored Procedures (SPs) per module.

Our porting exercise involves changing keywords of SQL 7 to SQL2K (eg. LTRIM, RTRIM, GROUP BY etc).

Is there a tool available online which can run thru the SPs and do the porting job? Otherwise I have to hand-code these changes

Also, has any one out there done this exercise before? What are the things to lookout for to avoid goofups?

Thanks in advance

View 2 Replies View Related

Migration

Feb 10, 2006

Hi evrybody,

I have been trying to migrate MY SQL to MSSQL and somehow cant do it.
I tried making Dsn for both of them, but the DTS wizard doesnt recognize MYSQL .

DOes anybody knwo how to do this?

thanks

View 3 Replies View Related

SQL 7 Migration

Jul 20, 2005

We have a SQL 7 server SP3 which we want to replace. The initial planis to create a new SQL 7 server and restore the database backups.My first question is there any need to restore the master databaseonce all the other db's are copied.We had planned to copy the databases and the msdb.Do all the DTS jobs, users, security etc come over in the msdb.Also is there any reason why we shouldn't upgrade to SQL 2000, arethere any compatiability issues with restoring the SQL 7 databasebackups to the SQL 2000 server?Ed

View 1 Replies View Related

Dts Migration

Apr 24, 2006



Hi,

How to migrate scheduled jobs from 2000 to 2005. Is this possible by doing bcp out and bcp in system tables which stores sql agent jobs from msdb database ?

Regards

Nit

View 1 Replies View Related

DTS Migration

Apr 24, 2006

Hi,

In DTS 2000 package dynamic property task an ini file is read and values for some keys are read. These values are nothing but name of servers on which to run some sql tasks. This dts package has three defined connections. So when the keys are read it will be either one of these three.

For eg. there are three sql tasks. sql1, sql 2 and sql3. sql1 needs to be run against server s1, sql2 against s3 and sql3 aginst s2. So the ini file sets three different variables connection1 to s1,connection2 to s3 and connection3 to s2. These variables are then used to run sql tasks accordingly.
When I migrated this dts package to .dtsx format and edited using SSIS, it gave me a blank format of vb script which we need to code. please help me out in this issue ?

Thanks,
Nit

View 2 Replies View Related

DTS Migration

Apr 23, 2006

I try to migrate DTS package to SSIS.
Within one DTS package AAA, it calls another DTS package BBB with inner variable.
I successfully migrate the BBB DTS package.
For my AAA package, I replace the DTS_Execute_Task_2000 with Execute Package task. But how do we pass the inner variable parameter ?

View 3 Replies View Related

Migration From 32-bit To 64-bit

Oct 4, 2007



Soon, i will be asked to carry enterprise databases on an Sql Server 2005 Server x86 edition to Sql Server Server 64-bit editon on another server. I am wondering that is it just fine to detach/attach databases. Is there any trouble that i may face?

Any experience?

View 4 Replies View Related

DTS Migration

Nov 27, 2007



Hi All,

Could you please tell me the Step by step process to Migrate the SQL 2000 DTS packages to SQL Server 2005 SSIS.

Thanks in Advance.


Manoj

View 1 Replies View Related

ASPNETDB Migration

Jul 12, 2007

I created a website using Visual web developer express edition (including SQL Express). No the user management section of the site (the login/logout database) was created automatically and SQL Server express was installed at my computer under the instance name of SQLExpress. I uploaded it to my web host and he hooked up the ASPNETDB for me. Now the problem is that ASPNETDB has an id password and I was given the MSSQL Server IP. How do I configure my website to accommodate that? Any help will be extremely useful!!!

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved