SAP

466

Solutions

719

Contributors

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Share tech news, updates, or what's on your mind.

Sign up to Post

Can the database password on the SAP Crystal Reports in SAP Business Objects Enterprise be updated using an API?

Is there an API .NET Framework available?

Where can the API be downloaded?

Does the API have to be installed on the both the client and server?
0
Free Backup Tool for VMware and Hyper-V
LVL 1
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

My extended family runs a small water sewage utility. I'm building apps that will allow us to increase customer service beyond the norm.

We've recently realized with SAP B1 (Blue Oceans) we can provide customer service that is typically only offered by utilities with 1 million plus customers.

My cousin and I will probably get the B1 cert and I'll get the SDK cert. But we don't have my dad's business mind.

My dad simply does not have the time to learn a complex software like SAP so I was wondering if they would make him learn the software or just teach him ideal configuration so he can instruct us.

My dad went to law school and he has a better business mind than some MBAs. If he learned how it worked we could really improve our business.

Can you answer the question and also do you recommend any schools that have online programs that focus on ERPs for utilities (if that's a thing)?
0
I have the need to get a BOM with all components , currently using Tc. CK86 , but this doesn't give enough information, so I want to do this by SQL, I come from oracle background and dont know how could I get this done in DB2 R/3, I do not have access to query builder or quickview , but i do have read access via SQL, I'm currently trying to figure out a way of getting this info using tables :

MAST Material to BOM Link
STKO BOM Header
STPO BOM item

Does any of you  have a solution for this?

In Oracle I did something like the following:
SELECT DISTINCT LEVEL
	,sys_connect_by_path(msil.segment1, ' @ ') AS "BOM TREE"
	,msi.segment1
	,lpad(' ', LEVEL, '') || msil.segment1 Cod_Component
	,msil.item_type
	,msil.description Desc_Component
	,BIC.component_quantity
	,msiL.primary_unit_of_measure
FROM mtl_system_items msi
	,bom_bill_of_materials bom
	,BOM_INVENTORY_COMPONENTS BIC
	,MTL_SYSTEM_ITEMS MSIL
WHERE msi.organization_id = 332
	AND BOM.ASSEMBLY_ITEM_ID = MSI.INVENTORY_ITEM_ID
	AND BOM.ORGANIZATION_ID = MSI.ORGANIZATION_id
	AND bom.bill_sequence_id = bic.bill_sequence_id
	AND nvl(bic.disable_date, sysdate) >= SYSDATE
	AND BIC.component_ITEM_ID = MSIL.INVENTORY_ITEM_ID
	AND Bom.ORGANIZATION_ID = MSIL.ORGANIZATION_ID
	AND msil.inventory_item_status_code = 'Active'
	AND msi.inventory_item_status_code = 'Active' connect BY prior bic.component_item_id = bom.assembly_item_id
	START
                  WITH msi.segment1 = trim(:parte)
        ORDER BY 2

Open in new window

0
Hello,

I am using SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version 14.1.4.1327 CR Developer.

When I drag and drop the date field from my service it shows an incorrect date on the report.

As shown in the screen shot image


How to overcome this issue? Even if I enter different parameter it shows the same incorrect date. It doesn't display date in database.
IncorrectDate.jpg
0
Hi,

i have a code of SAP as below, in the below code instead of 11, i want to give the cell reference of excel ,for example the cell range is in sheet1 J3, how do i relate this SAP. This code is in excel vba.

Please suggest

session.findById("wnd[0]/usr/ctxtPAR_27").text = "11"
session.findById("wnd[0]/usr/ctxtPAR_28").text = "11"
session.findById("wnd[0]/usr/ctxtPAR_31").text = "2017"
session.findById("wnd[0]/usr/ctxtPAR_30").text = "0"

Thank you!
0
Why can not the provider increase the size of the tablespace much more? What does it depend on? According to the image only broadened by 2%
www.png
0
We have an old application that we are in the progress of replacing with a new one.  This is being done by a consultant.
This old system used a fairly basic naming convention but one I believe is fairly standard (perhaps with SAP).  Anything that was customised by us was prefixed with ‘Z_’.  This might be a report, query or a security role.  This was the only naming convention that was strictly adhered to and one we inherited from previous employees and just carried on using.  One benefit of this was that when it came to update time (which stopped a long time ago), we could easily see what was customised and therefore made sure they weren’t removed as part of any update.  There was also a naming convention that wasn’t really stuck to for user roles where further information would be added after the Z_ to perhaps indicate a department or team.

The consultant is in the process of creating reports, security roles etc in the new application but has no plans to use a naming convention, which was a surprise.  Are there any serious usability or security issues associated with not using a convention?  Ideally I would like it to be agreed and implemented asap before too much customisation has taken place but want to make sure it is a point I really need to be ensuring is implemented or one I can forget about.
0
I'm an IT report developer with a few miles on my belt. Officially we are the Business Intelligence team. We use SAP Business Intelligence Suite 4.2, aka BusinessObjects. I remember James Martin back in the day (1990's) but haven't heard or read much about him, not that I'm the most well read person around. But I do have a pretty good library of software development books, from Karl Weigers to Steve McConnell to Gerald Weinberg, and "The Mythical Man Month". At the moment I'm trying to bring our organization into modern times in regards to Business Intelligence. What we have are awful legacy minded reports that no one uses, i.e., 85% of active OLTP users run NO reports (and the OLTP itself is a 1990's style system).

We are also trying to bring in Crystal Reports for high-end reporting, and other tools for "Dashboards".

Around here it's a totally legacy mindset, to include a CIO who's up there in years and is totally old-school, constantly referencing to James Martin and his approach. So is JM still a "classic" who's books should be on my shelf (to include reading them)? In order to influence the organization to "get modern", I have to start by convincing the CIO that there's a better way nowadays (to Business Intelligence).  Also, no one around here knows how to spell "agile".

Do you have a recommended James Martin classic or two, at least so I can be able to step up intellectually to where the CIO is coming from? And while I'm at it, any other classic books / …
0
I want to display a color band on crystal report with percentage on it. Is it possible to achieve by using Horizontal bar graph?
Below Image should be the output. ColorBand.jpg
0
Hi.

I am using Crystal Version SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version 14.1.4.1327 CR Developer

Is it possible to freeze one column and show the rest detail section.

My exact requirement is as per the the attached image
Coulmn-Format.png
0
Veeam gives away 10 full conference passes
LVL 1
Veeam gives away 10 full conference passes

Veeam is a VMworld 2017 US & Europe Platinum Sponsor. Enter the raffle to get the full conference pass. Pass includes the admission to all general and breakout sessions, VMware Hands-On Labs, Solutions Exchange, exclusive giveaways and the great VMworld Customer Appreciation Part

I am using Crystal Version SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version 14.1.4.1327 CR Developer. Whenever we export report in PDF using crystal report viewer the font size get reduce bu 10-15%. However viewer shows proper font size. What could be the problem ? There is a registry setting that controls this but same problem.
0
Crystal Version SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version 14.1.4.1327 CR Developer

In Line graph, I want to define Marker's dyanmically. Is it possible?

If field contains '1' then line graph marker should display triangle otherwise if field is '0' then line graph should display rectangle.

How to handle this in CR?
0
I had this question after viewing Backing up Sybase database Server using Veeam.

Hi,

I'm new in experts-exchange community. My company is on the way to use SAP Solutions. Right now I must choose backup concept for all VM's and databases. As far I know HANA backs up relatively automatic (dumps database and logs from RAM to storage). The issue what keeps me not sleeping is backup from Sybase ver. 11 databases, as database shouldn't be stopped at any time (24/7 availabilty) and this version have no support for VSS. I've readed that it's possible to HA (High Availabilty) and DR (Disaster Restore) only with VMWare solutions but I'm not sure - will consistency of database not be corrupted?...
Can someone give me a Tip what would be the best solution?
Database: Sybase 11
VMWare: vSphere 5.5
Veeam: 9.5.0.823
Many thanks for Your replies.
0
We have an enterprise system with several hundred canned reports (most of which are never used, but that's another story).  We use BusinessObjects Web Intelligence to write the canned reports, and also users run their own Ad hoc reports using the same Universes as the Developers.

We do not have a Data Warehouse, but I'm trying to sort out operational reporting (with no data latency) vs OLAP coming from a Data Warehouse.

We keep saying we want a Data Warehouse but we're really not all that literate about what that means, imo.

We say we're the Business Intelligence team, but what we really are is the Operational Reporting team, and we also allow users to run reports out of this system.

I'm trying to sort out how to "position" a Data Warehouse, and how people would actually use it along with the Operational Reporting system.

Also, our BusinessObjects Universes pretty much match the data model of the OLTP. So it's a big mess, imo. It's got every relationship in the same manner as the main data model. So we don't utilize Data Warehouse techniques (e.g., flattening of the data), we just basically re-build the data model in the Universe. So it ends up hard to maintain and confusing to the users.

So some specific questions
- am I on track to separate out operational reporting from Data Warehouse functions? If so, what's the right term for the operational reporting?

- is a data warehouse necessarily going to have some measure of data latency ? Say at most 24 …
0
i want to check if the Windows server has the following software installed on it.

IBM DB2
IBM IMS
Unisys RDMS
Unisys DMS
Sybase
Oracle

I believe we can check this if there are services running for each Software and need to know what service will indicate that the software is installed?
Any one please.
Thanks
0
I am using SAP Crystal Reports 2013 Developer Version

In chart expert there are already built-in charts available, but I want to add different chart type in it. How am I suppose to add different chart type in Charts option?

In the list of chart types provided there is no chart type called as Streamgraph or Cartogram, etc.

Is there any way I can add new chart type to crystal report?
0
Hi All,

   We are on SAP BusinessObjects 4.1.
There are a number of Crystal reports scheduled in Central Management Console. Off late, there were some reports which are hung in the Pending state after rescheduling. So, we rebooted the Windows server. After that, when we went to the History for those reports, the history page is all blank.
 There is one crystal report with a lot of Excel output files in the history. As soon as i rescheduled that report into Crystal Report output, the History pane displayed a blank page.

Does anyone know what the issue may be?
Please help.
0
I am using SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version 14.1.4.13247 CR Developer.

I tried to take print preview of a landscape report in Crystal Report Viewer, but it displays in portrait format. Even if I take a print preview of Portrait report, one side of data gets cut.

I read the archived questions asked by users from

https://archive.sap.com/discussions/thread/1792620

https://archive.sap.com/discussions/thread/3962673

https://answers.sap.com/questions/33771/crystal-report-viewer-previews-in-landscape-prints.html

but there is not a proper solution or there is no solution to it.

Is this bug solved? As we are facing lot of problems from client side.

Another problem with Crystal Report Viewer is that, it does not accepts Ctrl+P option for Print Command.
0
Hello Experts,

What kind of Crystal Reports license/software do I need to do:

1) Develop new reports
2) Publish Crystal Reports on the web so our users can run them by selecting different parameters


Thank you in advance!
0
SharePoint Admin?
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

I just upgraded to Crystal Reports 2016.  When I opened an existing VB.NET project in Visual Studio 2015, I noticed that there were a number of unresolved objects.  I removed the Crystal references, then tried to re-create them, but none of the four references in my prior environment appeared in the new one.  What references are required for designing and running a report?  Looked high and low, but couldn't find anything on the subject, including in the SAP CR forum.
0
Hi,

I am trying to plot some long and lats from a Sybase 16 database into a SSRS Map report using SQL Server spatial query.

I am using the below code to generate the spatial data in Sybase:
ST_Geometry::ST_GeomFromText( 'POINT(1 1)' )

Open in new window


but when I click n next the wizard states that the dataset does not contain any spatial field.

Please help.

Thanks, Greg
0
access is denied CS:DBDriver failed to load : C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\drivers\lib32\dbd_ctlib.dll Access is denied in windows 10 BI4.1 SP 5 while editing the universe connection.
0
I am using Sybase IQ select @@version SAP IQ/16.0.110.2014/10214/P/sp11/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit/2015-11-21 01:29:07

I need to build a tree on a table which consists more than Million records which links for every order_id. Need to find what it was replaced by existing order_id until the end and eventually need to find the various quantities of each of these order_id and get the max out of it.

Below is my sample data
create table #tmporder ( account_key varchar(50) not null, order_id varchar(50) not null, msg_type varchar(5) not null, repl_by_order varchar(50) not null, replaces_order varchar(50) not null, quantity numeric(12) not null, order_datetime datetime not null, order_status varchar(1) not null );

INSERT INTO #tmporder (account_key,order_id,msg_type,repl_by_order,replaces_order,quantity,order_datetime,order_status) VALUES ('123456','6473','PL','0','0',1000,{ts '2016-10-07 07:59:10'},'1');

INSERT INTO #tmporder (account_key,order_id,msg_type,repl_by_order,replaces_order,quantity,order_datetime,order_status) VALUES ('123456','6473','MO','6480','0',1000,{ts '2016-10-07 07:59:10'},'5');

INSERT INTO #tmporder (account_key,order_id,msg_type,repl_by_order,replaces_order,quantity,order_datetime,order_status) VALUES ('123456','6474','PL','0','0',1000,{ts '2016-10-07 08:16:05'},'1');

INSERT INTO #tmporder (account_key,order_id,msg_type,repl_by_order,replaces_order,quantity,order_datetime,order_status) VALUES 

Open in new window

0
Hi,
When I run sp_helpdb procedure I get the following information:

 device_fragments               size          usage                created                   free kbytes
 ------------------------------ ------------- -------------------- ------------------------- ----------------
 XX_data_01                       1024.0 MB data only            Nov 20 2015  2:08PM                  12400
 XX_data_02                       1024.0 MB data only            Nov 20 2015  2:52PM                  96432
 XX_data_01                       1024.0 MB data only            Nov 20 2015  3:26PM                 176784
 XX_data_02                       1024.0 MB data only            Nov 20 2015  4:05PM                 176800
 XX_data_01                       1024.0 MB data only            Nov 20 2015  4:54PM                 196720
 XX_data_02                       1024.0 MB data only            Nov 20 2015  5:08PM                 225680
 XX_data_01                       1024.0 MB data only            Nov 20 2015  5:19PM                 583200
 XX_data_02                       1024.0 MB data only            Nov 20 2015  5:34PM                 614080
 XX_data_01                       1024.0 MB data only            Nov 20 2015  6:00PM                 736784
 XX_data_02                       1024.0 MB data only            Nov 20 2015  6:29PM                 485808
 XX_data_01                       1024.0 MB data only            Nov 20 2015  7:06PM                 206848
 XX_data_02 …
0
Hi,
I've Sybase ASE 15.7 version.

Often I have a process that fill up my transaction logs, to see which process is responsible for filling up the logs I run this query:

select loginfo('<dbname>', 'database_has_active_transaction'),
    loginfo('<dbname>', 'oldest_active_transaction_pct'),
       loginfo('<dbname>', 'oldest_active_transaction_spid'),
       loginfo('<dbname>', 'can_free_using_dump_tran'),
       loginfo('<dbname>', 'is_stp_blocking_dump'),
       loginfo('<dbname>', 'stp_span_pct')
go

and after I kill the spid to free up space

kill <oldest_active_transaction_spid>
go

 
To details of the session I use "sp_who" procedure or this query:
select spid, status, hostprocess, program_name, clientname, loggedindatetime
from sysprocesses
go

But I'd like to get more details about the session that filled up my transaction logs, for example I'd like to know the exact SQL text that is being executed for "oldest_active_transaction_spid".

In addition is there a system table or history log file where the statements by a SPID are stored?

Thanks in advance!
0

SAP

466

Solutions

719

Contributors

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.

Top Experts In
SAP
<
Monthly
>