soujanyanaganuri23

Create meaningful business reports using SAP BO

Expand content
The maximum precious asset of any business is – information, that must be controlled efficiently to carry out each day business sports and get deeper insights into the efficient commercial enterprise...

The maximum precious asset of any business is – information, that must be controlled efficiently to carry out each day business sports and get deeper insights into the efficient commercial enterprise answers. as a way to make most of this statistics, organisations should want a device that stores and deprives statistics in an powerful manner.
SAP business items arises as the answer for all of the problems associated with information. It gives well timed correct information by way of performing as the idea for reliable decision making using the central repository that stores all the information. below BO, BI and effective company control is achieved on a unmarried incorporated platform. The view is uniform and efficient for all the employees and teams of your agency.
SAP MDM possesses several tools and programs in its territory so that you can make the commercial enterprise technique easy and geared up. It indirectly links people, commercial enterprise, and organizations in an effective manner. Altogether, it offers an output with applicable and efficient solutions to the queries of agencies. enterprise item can represent the whole of a processing device or as small because the statistics machine.
commercial enterprise gadgets promises business Intelligence to the companies. This business intelligence presents essential commercial enterprise records to clients, suppliers, managers and different people related to that precise commercial enterprise. BO is called as question reporting and evaluation tool. This tool helps users examine statistics present in numerous databases.
there are various modules below business items to permit enterprise intelligence sports of numerous businesses. considered one of them is Crystal reviews.

1 0 / Create an account to join the discussion.
Wayne Westlake
Follow / 6 Sep 2017 at 11:04pm / Toad for SAP Solutions
Latest post by on 7 Sep 2017 at 1:07pm

32-bit version of Free Toad?

Expand content
Is there no longer a 32-bit version of Toad starting with 3.2? Unfortunately some of our workstations require 32-bit Win7 for in-house applications.

Is there no longer a 32-bit version of Toad starting with 3.2?  Unfortunately some of our workstations require 32-bit Win7 for in-house applications.

60 2 / Create an account to join the discussion.
ZivIL
Follow / 6 Aug 2017 at 3:06am / Toad for SAP Solutions
Latest post by on 7 Aug 2017 at 8:22pm

Feature Question: Is there an option to save as .xlsx?

Expand content
Per subject, does the Toad client offer an option to save multiple (/all) open result sets as a single .xlsx file, under multiple spread sheet tabs? (A result set on each excel tab) Thanks in advance...

Per subject, does the Toad client offer an option to save multiple (/all) open result sets as a single .xlsx file, under multiple spread sheet tabs? 

(A result set on each excel tab)

Thanks in advance,

Ziv.

179 4 / Create an account to join the discussion.
ss
Follow / 1 Aug 2017 at 10:21am / Toad for SAP Solutions
Latest post by on 3 Aug 2017 at 7:15am

Toad Error

Expand content
After successfully make connection to Toad for SAP , when right click on any table to choose anything appear the attached error or when open editor to write query appear the same error this error appear...

After successfully make connection to Toad for SAP , when right click on any table to choose anything appear the attached error or when open editor to write query appear the same error

this error appear when working on anything in toad

when try from different machine and different user appear the same error

How can i solve this error

143 3 / Create an account to join the discussion.
soujanyanaganuri23

Taking SAP HANA and Growing it Offline is less Difficult now.

Expand content
Originally launched five years ago, HANA makes use of an in-memory computing engine where statistics is saved in RAM, for permitting quicker overall performance. however extra these days, Hana has up to...

Originally launched five years ago, HANA makes use of an in-memory computing engine where statistics is saved in RAM, for permitting quicker overall performance. however extra these days, Hana has up to date its functions with multiplied analytic abilities that possess tougher protection. SAP is aiming to make HANA, in-memory database, and analytics platform, to be had loose and offline to the developers. for you to make it less complicated for the builders to paintings with HANA, and to build applications on its platform, SAP has introduced new in-reminiscence specific edition this is free to down load and use at the desktop, computer or in the cloud. SAP is constructing its HANA platform surroundings, to courtroom builders past their client base to make it smooth for the builders to test with SAP HANA and its prototype.

This explicit version is freely reachable to companies of all dimensions and shapes. This version is a streamlined one to the unique model because it allows developers to deliver down HANA to the personal computer, on which he/she feels at ease with.
·         It delivers database, application, and advanced analytics offerings on a unmarried platform.
·         This new specific edition can be developed, examined and deployed for manufacturing applications that make use of a memory of 32 GB.
·         If builders desire, they could improve for more GB with a nominal fee.
·         It aids builders in constructing applications that execute transactional and analytical processing towards a single replica of each dependent or unstructured facts.
·         it is able to be advanced from the SAP Developer facilities and installed on commodity servers, laptops, and computers the usage of a binary installation package assisting both SUSE Linux Organisation server or purple Hat agency Linux.
·         it could also be installed on home windows and Mac OS through digital gadget installation image dispensed with SUSE Linux corporation Server.
·         it may be used offline and may be synced back online, every time important.
·         it is also to be had on cloud platform AWS and in SAP’s cloud appliance library, that offer deployment alternatives for public cloud platforms.

All new personal edition, SAP web IDE
on the HANA cloud the front, SAP enabled greater offline coding with SAP web IDE, the non-public version. The business enterprise has announced SAP net IDE for offline application development that performs automated synchronization upon connection to the cloud at the side of a brand new SDK (software program development kit) to accompany web IDE. It helps the fast introduction of latest application templates and integrates partner equipment into this internet IDE. companions and developers can build their very own plugins into it. all of the small-to-medium length organizations have get admission to to facts control and app improvement platform, this is frequently utilized by large-sized firms. each time connectivity is made to be had, net IDE syncs with cloud variations.
beneath are a few crucial functions of personal version of IDE:
·         can be installed on a private laptop for offline development by using a unmarried developer. It seamlessly integrates to different SAP HANA Cloud platform abilities.
·         ability to paintings from everywhere, even underneath the conditions of internet disconnection. The paintings can be resumed to cloud after a quick sync.
·         when subscribed to web IDE of SAP HANA Cloud Platform, it offers checking out, assessment and productive offline improvement for clients.

Conclusion
Each SAP HANA specific edition and SAP internet IDE, reflect virtual transformation and a renewed dedication to being attentive to the developer needs. SAP has made a clean declaration that its future in large part rests on Hana, in-memory computing platform. This new edition is making builders enjoy the ‘capacity to test and code on every occasion and anywhere they are’. The offline improvement is likewise a pass to position HANA, SAP’s apps and Fiori interface in the front of extra builders.  

91 0 / Create an account to join the discussion.
h.blum
Follow / 20 Jul 2017 at 2:46pm / Toad for SAP Solutions
Latest post by on 21 Jul 2017 at 11:46am

TSAP 3.2.0.96 ( HANA ) do not show views under explorer

Expand content
Hi, I have installed TSAP 3.2 And in the explorer, all tabs are ok, but the "views" tab do not show any views. Parallel with TSAP 3.1 I can see all views. There is no filter on "views"...

Hi,

I have installed TSAP 3.2

And in the explorer, all tabs are ok,

but the "views" tab do not show any views.

Parallel with TSAP 3.1 I can see all views.

There is no filter on "views" tab

Holger

200 4 / Create an account to join the discussion.
Omar Romero
Follow / 18 Jul 2016 at 12:23am / Toad for SAP Solutions
Latest post by on 21 Jul 2017 at 9:07am

Cannot connect to SYBASE IQ 16: "Could not load the encryption...

Expand content
Hello everyone, I´m new in the forum and in using Toad and I have the following problem: when I´m trying to connect to my SYBASE IQ 16.0.0.429 server by Toad 3.1.0.315 in a windows 7 64bit...

Hello everyone, I´m new in the forum and in using Toad and I have the following problem: when I´m trying to connect to my SYBASE IQ 16.0.0.429 server by Toad 3.1.0.315 in a windows 7 64bit lap-top I set all the right connection parameters but when I try to connect the following message appears: "Could not load the encryption DLL"dbfips16.dll"", I can connect by InteractiveSQL but I really want to use toad, can someone help me with this error? 

Thanks in advance and kind regards.

Omar Romero

Unanswered 2216 9 / Create an account to join the discussion.
wudeewen
Follow / 11 Jul 2017 at 10:08pm / Toad for SAP Solutions
Latest post by on 13 Jul 2017 at 9:57pm

Version 3.1.0.315 cannot display table columns

Expand content
I was using the freeware version 3.0.0.129 without any issue, until the 1 year expiration. I was prompted to download the latest (2016) version 3.1.0.315. Upon installation, I immediately found out,...

I was using the freeware version 3.0.0.129 without any issue, until the 1 year expiration. I was prompted to download the latest (2016) version 3.1.0.315.

Upon installation, I immediately found out, while the new version inherited the saved connections, when I connected to the server, it only lists the table names, but cannot retrieve the column definition that normally shows in the bottom of Object Explorer. Instead, I got error message

"Attempt to insert NULL value into column 21 in work table (table id 4288282623); column does not allow NULLS.  UPDATE fails."

I found if I close Toad for SAP and restart, the same error message will show up except with a different table id. I tried to use object_name() to get the work table name, only to get Sybase Database Error "Arithmetic overflow during implicit conversion of BIGINT value '4288282623' to a INT field ."

I suspect it's some script for creating the work table. I even copied the script from Tools --> Options --> SQL Dictionary --> Db.CommonSql --> DescribeTableColumns from the old version 3.0.0.129. I found it is the same as the new version. I could run the script in 3.0 before, but when I created an editor and pasted the script and run, the very same error message "Attempt to insert NULL value into column 21 in work table (table id 4288282623); column does not allow NULLS.  UPDATE fails." shows up.

The target SAP is ASE 16. On another connection to a ASE 15.7 server which the old 3.0 version had no issue on, it will connect to the server but no table will be listed. If I right click at the table area and select Refresh from the drop down, I will get an error "Invalid column name 'sysstat4'".

Is there any way to let me keep using the old but working version 3.0.0.129, instead of the 3.1.0.315? Or is there any way (such as updating the script) so the work table's column 21 can allow NULL value? In the current state it is not usable.

Thanks!

Answered 344 6 / Create an account to join the discussion.
ss
Follow / 9 Jul 2017 at 11:26am / Toad for SAP Solutions
Latest post by on 10 Jul 2017 at 11:38am

Toad

Expand content
Can we create hach file from Toad for SAP? Can we export tables as pcp file? Can we exported tables as inserted sql statements

Can we create hach file from Toad for SAP?

Can we export tables as pcp file?

Can we exported tables as inserted sql statements

304 5 / Create an account to join the discussion.
vineetkumar.kurrewar
Follow / 7 Jul 2017 at 1:40pm / Toad for SAP Solutions
Latest post by on 7 Jul 2017 at 1:47pm

Toad for HANA

Expand content
Hello Experts - I wanted to know if Toad for HANA 3.2 supports multi tenant architecture of HANA databases. As we already know that from HANA 2.0 multi-tenancy is a mandate. Awaiting replies...

Hello Experts -

I wanted to know if Toad for HANA 3.2 supports multi tenant architecture of HANA databases.

As we already know that from HANA 2.0 multi-tenancy is a mandate.

Awaiting replies. Thank you.

Regards

Vineet

221 1 / Create an account to join the discussion.
h.blum
Follow / 16 Nov 2016 at 2:32pm / Toad for SAP Solutions
Latest post by on 5 Jun 2017 at 8:28am

select statement does not run in Toad for SAP but in HANA studio

Expand content
Hi@all, this script does not run in Toad for SAP ( HANA ) 3.1.0.315 select X.COMPETENCE_CENTERS, X.ESTIMATED_PROJECT_COSTS_KEUR, X.IMPACT_ON_EBITDA_PER_YEAR_KEUR, round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR...

Hi@all,

this script does not run in Toad for SAP ( HANA ) 3.1.0.315

select
X.COMPETENCE_CENTERS,
X.ESTIMATED_PROJECT_COSTS_KEUR,
X.IMPACT_ON_EBITDA_PER_YEAR_KEUR,
round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1),
case
when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 0.1 and 0.9 then '0.5'
when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 1.0 and 1.9 then '1'
when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 2.0 and 2.9 then '2'
when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 3.0 and 3.9 then '3'
when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 4.0 and 4.9 then '4'
when round(case when X.IMPACT_ON_EBITDA_PER_YEAR_KEUR != 0 then X.ESTIMATED_PROJECT_COSTS_KEUR / X.IMPACT_ON_EBITDA_PER_YEAR_KEUR else 0 end,1) between 5.0 and 5.9 then '5'
else '9'
end
from TOP_PROJECTS X;

I get only "SAP HANA Database Error:"

but no error number.

In SAP HANA studio 2 it works.

Any idea ?

1081 2 / Create an account to join the discussion.
h.blum
Follow / 3 Mar 2017 at 8:53am / Toad for SAP Solutions
Latest post by on 5 Jun 2017 at 8:27am

Script not running in Toad but in HANA Studio

Expand content
Hi, this script will not run in Toad but in HANA Studio: select x."Payback period in year", case when x."Payback period in year" > 0 and x."Payback period in year"...

Hi,

this script will not run in Toad but in HANA Studio:

select
x."Payback period in year",
case
when x."Payback period in year" > 0 and x."Payback period in year" <= 1.5 then '1'
when x."Payback period in year" > 1.5 and x."Payback period in year" <= 2.5 then '2'
else 'x'
end
from TOP_INVESTMENTS x

And I get not error message / number in Toad from HANA

Holger

Unanswered 841 9 / Create an account to join the discussion.
sonic_spin
Follow / 18 Nov 2015 at 12:22pm / Toad for SAP Solutions
Latest post by on 24 May 2017 at 2:36pm

Toad for SAP Solutions ( IQ connection problem )

Expand content
I'm trying to connect to Sybase IQ 16 with Toad for SAP Solutions 3 from my laptop as a client. After setting up all connection manager fields I’m getting a massage which states... <Database...

I'm trying to connect to Sybase IQ 16 with Toad for SAP Solutions 3 from my laptop as a client.

After setting up all connection manager fields I’m getting a massage which states... <Database error> <Database server not found>

Do i need an ODBC connection on my laptop (client side?)

 

Note: with same connection settings Aqua Data Studio connects without any problem.

Answered 6185 15 / Create an account to join the discussion.
AzaMull
Follow / 14 Mar 2017 at 6:41pm / Toad for SAP Solutions
Latest post by on 29 Mar 2017 at 2:03am

Tables are locked by 'Toad for SAP 3.1.0.bugs.1109' when using...

Expand content
There is a problem with Toad for SAP which causes issues during production releases which had DDL changes. How to reproduce: 1, Open Toad -> and connect to a Sybase IQ server via Connection manager...

There is a problem with Toad for SAP which causes issues during production releases which had DDL changes.

How to reproduce:

1, Open   Toad -> and connect to a Sybase IQ server via Connection manager

2. Go to View- > Object Explorer.

Now Check for table locks by using sp_iqlocks. You will see shared locks on ALL  tables on the server, across all schemas.

Thus, if someone has a Toad session open during the release,  any DDL on a tables such as alters, will fail with a table is in use error.

I don't understand why Toad needs to lock all tables .

We have many Toad sessions connected, and this is not feasible for us to control everyone and tell them not to use Toad during the release.

Has anyone come across this issue and do you have solution ?

Version : Licensed Toad for SAP 3.1.0 bugs 1109

Unanswered 679 4 / Create an account to join the discussion.
thompsojmd
Follow / 2 Feb 2017 at 4:41pm / Toad for SAP Solutions
Latest post by on 2 Feb 2017 at 7:03pm

Can Add/Remove Connection be locked in Connection Manager

Expand content
I am looking at deploying Toad to a large group of Data Analysts and Developers. Some should have access to production data and some should not. I am wondering if there is anyway to lock the ability to...

I am looking at deploying Toad to a large group of Data Analysts and Developers. Some should have access to production data and some should not. I am wondering if there is anyway to lock the ability to add or remove connections in Connection Manager. I really like the ability to import groups of connections, but I don't want many of the users to be able to change this for security reasons.

680 2 / Create an account to join the discussion.
Deandyno
Follow / 30 Jan 2017 at 7:03pm / Toad for SAP Solutions
Latest post by on 31 Jan 2017 at 8:41pm

User database groups

Expand content
Does Toad for SAP have a way to extract the DDL to include the group grants specific to database groups in Sybase ASE ? Thanks, Dean

Does Toad for SAP have a way to extract the DDL to include the group grants specific to database groups in Sybase ASE ?

Thanks, Dean

Unanswered 646 2 / Create an account to join the discussion.
hcsiu
Follow / 20 Jan 2017 at 2:50am / Toad for SAP Solutions
Latest post by on 20 Jan 2017 at 7:25am

Toad for SAP Solutions 3.0.0.129_Mod. error

Expand content
When we run Toad_for_SAP_Solutions_3.0.0.129_Mod.exe, there is an error message saying: C:\Users\<userid>\AppData\Roaming\Quest Software\Toad for SAP Solutions 3.0\SQLFormatter\Long Format Leading...

When we run Toad_for_SAP_Solutions_3.0.0.129_Mod.exe, there is an error message saying:

C:\Users\<userid>\AppData\Roaming\Quest Software\Toad for SAP Solutions 3.0\SQLFormatter\Long Format Leading Comma Uppercase.xml' already exists.

We checked and the xml file is not found.

Please kindly help how to fix this problem.

Thnaks a million.

Best regards.

659 1 / Create an account to join the discussion.
Deandyno
Follow / 5 Dec 2016 at 6:06pm / Toad for SAP Solutions
Latest post by on 15 Dec 2016 at 3:52am

Query Plan doesn't show

Expand content
I see that the Query Plan window was supposed to be fixed in 2.1 version, we're running 3.0 and no information is populated in the Query Plan window. This is for straight SQL and thru a procedure...

I see that the Query Plan window was supposed to be fixed in 2.1 version, we're running 3.0 and no information is populated in the Query Plan window.

This is for straight SQL and thru a procedure, nothing in the window in either case.

1120 7 / Create an account to join the discussion.
plankton
Follow / 14 Dec 2016 at 2:06pm / Toad for SAP Solutions
Latest post by on 14 Dec 2016 at 3:00pm

Issue With Executing Multiple Select Statements- Results Are Produced...

Expand content
Hi, I'm new to Toad and am currently using Toad for Sybase version 2.1.0.2921. I need the functionality that was built in for this post ( http://www.toadworld.com/products/toad-for-sap-solutions...

Hi,

I'm new to Toad and am currently using Toad for Sybase version 2.1.0.2921. I need the functionality that was built in for this post (http://www.toadworld.com/products/toad-for-sap-solutions/f/24/t/21931?pi11637=2). Is there an enhancement for Toad for Sybase that would give me this functionality? If not, would I be able to switch to Toad for SAP and still work off of a Sybase-ASE server?

-Thanks

Unanswered 800 2 / Create an account to join the discussion.
Danny Torres
Follow / 1 Nov 2016 at 2:16pm / Toad for SAP Solutions

We are now on Twitter!!! Contact a Technical Support expert today

Expand content
Do you have a quick support question and short of time? Contact us Via Twitter @ QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

Do you have a quick support question and short of time? Contact us Via Twitter  @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

741 0 / Create an account to join the discussion.