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

Hi,
I am working with Sybase Replication 12.6 using MSA.  There are reports that run against about 60 tables in the replicated database.
The application team wants to suspend updates to those tables while the reports  are  running.  The report takes approximately one hour.
There are about 100 other critical tables in this database and they prefer not to suspend the connection for the entire database.

It seems I can create a 2nd database and define a subscription but there are a few tables that are extremely large that are not part of the report.
If  I define a subscription for a 2nd replicated database, I need to perform a dump/load- so this replicated database will need to be as large
as the source database and unfortunately with Sybase 12.6, I can't shrink the database - totally wasted space.

Basically, what I need in addition to my MSA replicated database is a snapshot of the database or a subset of the database.
Is there a way to suspend updates for only the tables in the report for my current replicated database?

I thought about creating a database at primary with only views for the tables in the report then trying to replicate that database.
Then I can suspend connections to that database.  Any reason this will not work?

Any other ideas on how to accomplish this?


THANK YOU!!!

what is the name of the 'management console' which is used to manage security/permissions/users in sap business objects? And where does all the configuration data reside relating to the security configuration, e.g. does business objects come with a standard database for storing configuration information, and out of interest is that typically oracle/mysql/MSSQL.

Hi Experts,
I need to change one of my Sybase databases to be "Inactive", I need to know the value to be updated in "status" column in "sysdatabases" system table.

Thanks,
Daniel Mina

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.

http request to receive a login token from BusinessObjects worked a week ago, but no longer works, but https works.

The custom application to call BusinessObjects cannot process https call to BusinessObjects, so it's just using http.  The Windows Server 2012 had some recent updates and that seems to be the point the http call stopped working. However, the https call also doesn't work on the test server, also a recent occurance, previously http call worked, but that server hasn't changed.

We are calling BusinessObjects to get the login token, using custom.jsp, The call is this: http://businessintel.xxx.edu/BOE/OpenDocument/opendoc/custom.jsp, returning a token such as [my.server].xxx.edu:6400@1035920Jat23ZRZurWSuUdChkH7potPPeh4WnA4L1035918JhHah7YSxtrZnVHLEphyINv3xF2BcOI2O

The http call results in http error 404.

An http call to an outside link works - http://www.daggerpress.com/

So Windows Server 2012 now cannot (all of a sudden) call SAP BusinessObjects with http

I realize this is an environment issue that you won't be able to troubleshoot. Also it's Business Objects so we are pursuing assistance in other places.

But just thought I would see what anyone might say as far as how to further troubleshoot this.

Business Objects BI Suite 4.2 SP-05
Windows Server 2012

Hi Exchange experts

i dont know how this has to be done so i need help here

we have our ERP system SAP and we need to make a changes about meetings or date and we need an automatic configuration between SAP and exchange calendars

that when the user in SAP change the data about meeting this changes will take effects in the email calendar

someone talk about something called exchange web services

which will use the web mail of exchange to do this changes

i don't know about this

plus if you have any other idea to meet such aim

HI Experts

just a question

some vendors dose not let you get the certificate even if you pass the exam without attend their training

for example  Vmware  so even you pass VCP exam you are not VCP certified till you attend the training

my question

what about


Citrix  -- Veeam  - Microsoft  - SAP

if anyone knows kindly update me


thnaks

Dear Experts,

Could you please have a look this short code part, briefly its target is assigning a button text (from SAP application) to a variable, but if there is no such button then going further:

ErrMes = session.findById("wnd[2]/usr/txtMESSTXT1").Text
Debug.Print ErrMes
If ErrMes Is Nothing Then
    GoTo NoChangeMessage
Else
    ErrMes = session.findById("wnd[2]/usr/txtMESSTXT1").Text
    If InStr(1, ErrMes, "change", vbTextCompare) > 0 Then
    session.findById("wnd[2]/tbar[0]/btn[0]").press
    End If
End If

Select all Open in new window

Actually it has the issue that the ErrMes variable got a value (as Debug.Print shows 'No changes were made' text assigned to it from the button), but then the VBA script stops at line

If ErrMes Is Nothing Then

Select all Open in new window

with error message:

Run-time error '424'
Object required


Could you please advise what is the nature of the issue there and eventually how to eliminate?

Thanks in advance,

Dear Experts,

Could you please advise in Python how to get all the attributes/methods of an object?

Actually I need to write a Python code which works together with SAP application and it took almost a week to find in separate Python codes through Google, that there are 'Info' and 'SystemName' attributes for the "SAPGui" object.

This code so works already with showing the system name of that connection in SysName variable:

import win32com.client

SapGui = win32com.client.GetObject("SAPGUI")
print(SapGui)
Appl = SapGui.GetScriptingEngine
print(Appl)
Connection = Appl.Children(0)
print(Connection)
Session = Connection.Children(0)
print(Session)
CollCon = SapGui.GetScriptingEngine.Children(0)
print(CollCon)

SysName = Connection.Children(0).Info.SystemName
print(SysName)

Select all Open in new window

Now it can be even in one line:

FullAttr = win32com.client.GetObject("SAPGUI").GetScriptingEngine.Children(0).Children(0).Info.SystemName
print(FullAttr)

Select all Open in new window

And here comes my question concretely - what is the way to find these attributes like Info and SystemName in Python for such outside application? I am using Spyder for writing Python code and the default tool which brings a list after pressing '.' for the object, it does not work for such outside application

Thanks in advance,

Hi,

How to call windows exe file in ASP.NET Application which has been hosted in IIS.?

The exe does, fetching records from SAP and keep it in local folder.

I have been facing the below issues.

1) I am not able to call the exe file in ASP.NET file.
2) I am not able to connect SAP through ASP.NET which is hosted in IIS.

Can any one give idea/suggestion, how to proceed above scenario...?