Getting ready to upgrade to SAP BusinessObjects Business Intelligence 4.  What built-in tools (add-ons) are available that are an absolute must-have?

Hi Experts,
I have a problem restoring Sybase database from Sybase 15.7 to SAP 16, on the same instance I did restore another database from the same Sybase server with no issues.
The problem happens in the online database step, load command complete successfully. Both Sybase servers are running on Windows OS.

Below is the output for online database command:

Started estimating recovery log boundaries for database 'XX'.
Database 'XX', checkpoint=(4834613, 16), first=(4834613, 16), last=(4834613, 16).
Completed estimating recovery log boundaries for database 'XX'.
Started ANALYSIS pass for database 'XX'.
Completed ANALYSIS pass for database 'XX'.
Recovery of database 'XX' will undo incomplete nested top actions.
Database 'XX' appears to be at an older version '15.7' than the present installation at version '16.0 SP01 PL02'; ASE will assess it, and upgrade it as required.
Database 'XX': beginning upgrade step [ID     2]: validate basic system type data 
Database 'XX': beginning upgrade step [ID    75]: executing SQL statement ("update syscolumns set type=66, user...")
0 row(s) affected.
Database 'XX': beginning upgrade step [ID     9]: executing SQL statement ("if exists (select 1 from syscolumns...")
Database 'XX': beginning upgrade step [ID    10]: alter table (table sysobjects)
Database 'XX': beginning upgrade step [ID    69]: executing SQL statement ("if 2 = (select count(name) from sys...")
0 row(s) affected.
Database 'XX': beginning upgrade step [ID    

Select all Open in new window

…

After migration of webI reports from SAP BO 3.1 to SAP BO 4.2 Refresh on Open does not work

Records Returned when Browsing Fields or Parameters Lookups:
In crystal reports there used to be a location (I think in the registry keys and possibly under the file options or report options section) where you could set the number of records returned when showing a parameter list or browsing window? Is that still used or available? If so where is it? I have CR 2016. I have tried searching Google and I must be putting in the wrong search terms again.

I did find this but cannot see 2016 nor hardly understand the format of the content or where the setting is. Link to Website.

SAP BI 4.1 - WEBI
This has one data source - a derived Universe for CA Service Desk Manager.

I am trying to add a variable to a report.  This is to check if a field is null.  If it is, return one value; if not, return another.
NOTE:  This issue occurs with ALL functions which have parenthesis - NOT just "isNull()".

Steps to Reproduce:

1.  Open WEBI.
2.  Open an existing report or create a new one where results return at least two fields, one of which may have NULL values.
3.  Create a new variable.(example)
-- Name:  vFirstGroup
-- Qualification:  Dimension
-- Formula:  
      =If isNull([First_Field]) Then [Second_Field] Else [First_Field]
a.  Validate the formula.  Results:  The formula is correct.
b.  Select OK to save the variable.  Results:  Error
    ///////////////////////////////////
Web Intelligence
There is no opening parenthesis after function "isNull" at position 11 (IES 10060)
   ////////////////////////////

The on-line documentation for "IES 10060" says to add the missing parenthesis.  That is not the case here.

This does not occur if creating a variable which does not include functions with parentheses.  For example, this works:
  = If [First_Field] = 0 Then [First_Field] Else [Second_Field]

Thanks in advance.

'Breeze

In one my tables (not very big, just 700 MB) , the performance for some of the queries goes bad in few days. I did some analysis and found that one of the index on that table , its large i/o efficiency value keeps going down and becomes 0.4.  when we do full reorg rebuild it becomes 1 and performance improves.
I want to know why the large io efficiency values goes down. there are around 1million DML operations on that table on daily basis.

sybase experts please throw some light as always you do.

Need to have a pie chart in a Crystal Report reflect the FMV %. In other words, as the example attached, I need to show 21% of the pie chart out of 100%. I have already added the same field that FMV % is using but cannot figure out how to make it display in percentage within the Pie chart.

Any guidance will be greatly appreciated.
Capture.JPG

How to do large set of data movement from SAP ASE/ ASE IQ server to other RDBMS say SQL server.??
The data is need to move is around 2-3 TB , could you please provide a complete step to step approach.
My Sybase IQ tables are too big. A detailed explanation will be highly appreciated.

Thanks

Hi Experts,
I need installation packages for Sybase ASE 12.5, 15.0.3 & 15.5 on Linux. Could anyone send to me a download link?

Regards,
Daniel

Dear Experts
At present we are using CRM application which is hosted on premise and it is mainly used for handling the support cases, automated email alerts and to store all the case related data, repair and maintenance data ( all data are imported  only , ie, operational users will not use instead all these to be imported  ) and tool is only used for reporting and analytics purpose only . Now that for other business process where the operational users will use in every stage  hence the need for technology solution in additional to above mainly on following business process and solution to be deployed on premises only.
1.       complete material movement tracking and capture the activities involved and automated email notifications and if the delay escalation rules .  
2.      Service, repair and maintenance  
3.      Warehouse/logistics management
4.      Inventory management
5.      Invoice management/HRMS/Vendor bills/salary # this is optional mainly 1 to 4 is important
We cannot go for cloud solutions the solution to hosted on premise.  Please suggest the ERP application that can be best suited for above should we have to evaluate Microsoft dynamics ERP AX , SAP  or any other where it to be used for operational and also for reporting and analytics . please suggest the best suited ERP or other solutions. Thanks in advance.

I need to add an additional criteria to the following formula and I tried but it is not working??
This one works:

{="Unique Numbers in SAP = "&SUM(--(FREQUENCY(IF(Sheet2!C2:C50000<>"",MATCH(Sheet2!C2:C50000,Sheet2!C2:C50000,0)),ROW(Sheet2!C2:C50000)-ROW(Sheet2!C2)+1)>0))}

This one does not work:

{="Unique Numbers in SAP = "&SUM(--(FREQUENCY(IF(,Sheet2!H2:H50000"<>SESA"),IF(Sheet2!C2:C50000<>"",MATCH(Sheet2!C2:C50000,Sheet2!C2:C50000,0))),ROW(Sheet2!C2:C50000)-ROW(Sheet2!C2)+1)>0))}

Hi

We are running ASE 15.0 (with character set latin-1 on Solaris 10).  We want to convert the charset of database server from latin-1 to UTF-8 to support  Chinese characters.
can anybody help us to list the steps involved in this charset conversion?  We understand we may have to bcp out/in all the tables unless the data stored in tables are only ASCII-7.  Is there any easy method to convert to UTF-8 without bcp in/out?

We have setup Warm standby using Sybase Replication Server. Do we need to change the charset of Replication server too to support UTF-8 along with dataserver? Kindly advise.

thanks
Chan

I am trying to use a quantified expression to check every line item in a purchase order to see if the confirmed date and quantity (E2EDP20_EDATU, E2EDP20_WMENG) match the order date and quantity (E2EDP03_DATUM, E2EDP01_MENGE) within each G03 node..  

This is an SAP ORDERS IDOC.  If the E2EDP01 ordering data matches the E2EDP02 and E2EDP20 order confirmation the order is accepted unchanged.  If the E2EDP20_WMENG quanity is different than E2EDP01_MENGE we detect a change.  If the EDP20_EDATU  is different than E2EDP01_DATUM we also detect a change.

There  may be many G03 groups each with a new line item within to be checked.

When I enter this code below I get "Xpath is Invalid".  Am I not supposed to be able to use pos$ as a variable for each //G03 and use it as part of the Xpath to the E2EDP03 and E2EDP01?

<xsl:value-of select=" if (every $pos in //G03 satisfies (pos$/E2EDP20/E2EDP20_EDATU=pos$/E2EDP03[E2EDP03_IDDAT='002']/E2EDP03_DATUM and pos$/E2EDP20/E2EDP20_WMENG=pos$/E2EDP01/E2EDP01_MENGE)) then 'NOCHANGE' else 'CHANGE' "/>



<?xml version="1.0" encoding="UTF-8"?>
<!-- Based on format description: ordrsp_sr3_ord04 --><ACTIS>
  <Ein_IDOC>
  	  <G01>
  	  	...
  	  <G02>
				...
      <G03>
         <E2EDP01>
            <E2EDP01_POSEX>000010</E2EDP01_POSEX>
            <E2EDP01_ACTION>001</E2EDP01_ACTION>
            <E2EDP01_MENGE>960.000</E2EDP01_MENGE>
            <E2EDP01_MENEE>PCE</E2EDP01_MENEE>
            <E2EDP01_PMENE>PCE</E2EDP01_PMENE>
      

Select all Open in new window

…