Questions tagged [business-objects]

BusinessObjects is a business-intelligence suite from SAP.

0
votes
0answers
7 views

HANA Studio Star Join performance left join vs inner join on Graphical calculation view (SAP ECC)

First off, if you have no or limited experience with HANA Studio and Business Objects move along; this likely will not make sense to you. Let's say we create a Dimensional calculation view joining ...
1
vote
1answer
13 views

Is there a way to export the actual number from WEBI to Excel after I've applied formatting in WEBI?

I am creating a report in Business Objects Web Intelligence, and there is a requirement to format a number in millions. For example, $4,879,987.23 would be formatted as $4.9M. I tried both a custom ...
1
vote
1answer
21 views

How to capture SQL fired from Business Object Deski

I am new to Business Objects Deski. I was referring few older reports to understand how actually it works. There is one report where there are multiple Data Providers created and in report body ...
0
votes
1answer
28 views

SAP Webi Frequency Table

I am quite new to using Business Objects (SAP HANA) Web Intelligence (Webi). As you can tell, I don't even know what to call this environment I am working in. I have a table with multiple columns. I ...
0
votes
1answer
23 views

Why does the max function aggregate?

I want to return the maximum value in a column in a block with values for 13 periods. Max([CountVariable]) returns the value against each period. Max([CountVariable] forAll([Period)) returns the sum ...
0
votes
0answers
14 views

Generate file on SAP Data Services and upload it on Google Drive

I have a projet where I should generate a csv file and upload it in our shared repertory on Google Drive. Is it possible to upload the file on Google Drive? PS: I m not talking about Google Cloud ...
0
votes
1answer
22 views

Add custom icon to the shape list in Spotfire

I want to add a custom icon in the icon list for more meaningfull shapes
0
votes
1answer
30 views

Using sub-query in FROM instead of WHERE - SAP BO Web Intelligence

I am trying to use the WebI query builder to achieve something I can already achieve writing a pure SQL query. Requirement: Count the percentage of tickets where a specific group took longer than ...
0
votes
0answers
39 views

CDS annotation @ObjectModel.alternativeKey does not affect BOPF object

I am using a CDS view to generate a Business Object. I need to use alternativeKeys so I'm using the @ObjectModel.alternativeKey. However, it does not add the alternativeKey to the Business object node....
0
votes
1answer
85 views

How to solve dependency issue of CrystalDecisions.CrystalReports.Engine.dll?

i've created a project in vb.net 2013 using crystal report CRforVS_13_0_24. On my side in warning secion error prompt "Unable to find dependency 'BUSINESSOBJECTS.LICENSING.KEYCODEDECODER' (Signature='...
0
votes
1answer
10 views

How do I sum rows in Business Objects based on multiple same dimensions?

I have a report in Business Objects like below. Name DOB DATE Balance Test 121212 01012010 10 Test 121212 02022012 10 Nest 050599 01012010 20 Nest 050599 02022012 10 I would like to create a ...
1
vote
1answer
44 views

Display all dates even if there is no data

I am attempting to display all the dates within a range even if they do not have data for the particular date. Our employees do work 24/7 365 ( like everyone else) so there are dates within my time ...
0
votes
1answer
18 views

How to add data from 2 queries into 1 table in webi

I have 2 queries. The first query is from the webi universe which has: Staff ID Arrival Date Leave Date The 2nd query is an Excel data query that has: Staff ID Test Date What I am want to do is ...
0
votes
1answer
16 views

How can I group data by matching identical cells in same column then counting instances of a related column?

data output I am pretty new to Webi and am having an issue creating a variable. I'm trying to check if there is more than 1 email address for each entity legacy account number and if 1 of the contact ...
0
votes
0answers
17 views

BO WEBI highlight orders when 2 different details are equal

I have report with orders in and out. I'm trying to filter out all the orders that went out. So if destination ID (inbound) equals origin ID (outbound) I was trying something like this: = (If [S ...
0
votes
0answers
27 views

Range filter on a Dimension in SAP ANALYTICS CLOUD

I need to create a range filter in SAC and to create range filter in SAC, column should either be date or number type. I wanted to create a range filter on a Dimension but in SAC dimension is ...
0
votes
0answers
17 views

Webi Percentile over aggregated rows

I want to have the 95% lead time in days as a variable. However, when a certain number occurs more than once, the calculation only takes that number once in the calculation. Example: Leadtime ...
0
votes
1answer
91 views

Subtracting hours from timestamp in SAP BO Webi report

Need to subtract a timestamp in a date column in SAP Webi report. Timestamp is in string for example "20190302000001" and there is no proper structure due to information pulled from SQL server. I ...
0
votes
0answers
17 views

SAP BO Webi - Match Loss Date to the Period

I created a Query 1 initially using data organized in a Universe. Next, I had to upload an excel doc as a separate Query 2. Query 1 - As of Date | Loss Date | 1/26/19 (4/1/16 - 1/26/...
0
votes
0answers
47 views

SAP BO RESTful API returns binary

Summary: I have an issue with consuming SAP BO RESTful API. Instead of an expected HTTP response, I'm getting a binary output. Details: I have two SAP BO servers. One of them works as expected. The ...
1
vote
0answers
35 views

How does log4net work on Application server

I did configure and program all the required logging.cs and log4net.config in my .NET web application. My application is deployed with all the web code files on Web Server and all business dlls on ...
0
votes
1answer
26 views

how to create a table in SAP WEBI

I have a table that I would like to be similar to something like this? Appreciate the help on this thank you.
0
votes
0answers
62 views

Return MAX update date in SAP Business Objects 4.0webi

I am working on a query in business objects to capture data at its current state. There are a lot of 'update date' (i.e. with every update date per unique index, I am receiving a row of data) fields/...
0
votes
0answers
19 views

My SQL query runs well in SQL dev and returns Two records but it returns blank value when I use same query in “Add Command” in Crystal report

I have a SQL query in sql Developer(Oracle Database),which run well and returns 4 columns and 2 records but if I use the same query in Add Command in Crystal report it returns blank values. p.Name (...
0
votes
1answer
13 views

Extract group of characters from an object/string

I have a very long string of characters that contain a date and time. How can I extract just the date part and the time part from it? Here's the string: 0:2019010309130000:0.000000:126:0 I just need ...
0
votes
0answers
53 views

Compare GL accounts between three systems ECC, S/4 and MDG in SAP BODS

I am stuck on how to proceed to compare G/L accounts between three systems ECC,S4 and MDG in SAP BODS and have the BODS output as Output ( Exception Only - If Records are missing or Data Is missing ...
1
vote
0answers
70 views

Open Business objects report in iframe

I am trying to embed a BO report in my html page using below code. I am seeing this peculiar problem. When i open this for first time, entire page redirects to BO site and asks for login name and ...
0
votes
1answer
72 views

Line Break in OBIEE 11g

I am a creating a report using OBIEE 11g and need to figure out the line break. For example, I have the following variables: Account Name, Address, City, State etc...I want to be able to have all ...
0
votes
0answers
37 views

Fetch min date irrespective of the report date range

I am trying to fetch min date in my report in webi.The report is build from 01/01/2018 till 10/31/2018 for two different promos. But these promos began and ended beyond report start and end dates ie ...
0
votes
0answers
10 views

Lost autofit property of Business Objects cell when I ask the content to by read as HTML

My database users an advance text editor which saves HTML to the field. When i ask BO to read the object as html it correctly interprets the information as html but i lose the ability to autosize the ...
0
votes
0answers
32 views

Business Objects- Generate report by using data from RESTFUL web service

I would like to access the data of a web service and render it to a BO Report. While creating I could see that data source connection supports only SOAP based web service and there is no option to ...
0
votes
0answers
24 views

How to concat and sort many bo objects in one object

I have a product id And four categories. (Objects in BO) Product id Categ 1 Categ 2 Categ 3 Categ 4 Each product Can have one or many catégory so I would like to sort alphabetically this objects and ...
0
votes
0answers
25 views

Business Objects webi reporting on IBM TRIRIGA

I have seen few documentations on creating crystal reports on top of tririga. Just wanted to know the feasibility of developing a BO universe on top of Tririga. I don't see connecting to Tririga( ...
0
votes
0answers
63 views

Cell height and width of excel file export from Crystal Reports and BI Launch Pad are compressed

Both of the cell height and width of excel file export from Crystal Reports and BI Launch Pad are compressed. Is there a way to fix this problem? Thanks. CR design mode Excel output CR and BI ...
0
votes
1answer
41 views

Assign the row number in PLSQL for the user entered input in the Business Objects screen

I am using SQL query against Oracle database and its get the input from Business Objects. Example: SELECT EMP_NUM from table1 Where EMP_NUM IN (@PROMPT VALUE,MULTI) i.e in Business Objects screen, ...
0
votes
1answer
26 views

How to view and disable auto crystal reports in business objects enterprise release 2?

I'm new to business objects and have been assigned a ticket to disable a certain auto crystal report that sends email to specific people with a pdf attachment. Now I need to find and totally disable ...
0
votes
1answer
418 views

SAP BO 4.2 Report Export to Excel, PDF, CSV Excessive run-time

Has anyone run into an issue with exporting a report to Excel, PDF, or CSV on the SAP/BO server and had to wait up to 40 minutes for the report to finish exporting on the server? The report renders ...
0
votes
0answers
28 views

change X axis data in infochart in SAP BUSINESS OBJECT DESIGN STUDIO

I have a requirement in which I need to rename a data from x-axis of an infochart. name salary Abc 120000 So in bar chart, X axis will be having name: Abc & Y axis will have salary ...
0
votes
1answer
63 views

SQL -Oracle - Return results in the exact order on the input Entered in the BO Screen - Solution updated

I used the below query to get the Dateofbirth and Mark values. SELECT b.Subject_name, a.Empnum, Dateofbirth,b.mark FROM Employee a, Subject b WHERE a.Empnum = b.Empnum AND Empnum in (<...
0
votes
0answers
155 views

SAP Business Objects 4.2 Integration

I need help on how to migrate our java codes with regards to connecting to business objects. It was recently migrated from version 3 to 4.2. We are using java 8 running on WAS 9. I have tried updating ...
0
votes
1answer
22 views

result is null for multiple columns display in single column

BI report: Currently 'part' column may have missing data for other columns. If entry for field( item 1, item 2)is null then display. Only want to Display null entries but in a single column where the ...
0
votes
0answers
42 views

error in open document with Business Object SAP InfoView

opening document with Business object infoview sap returns below error: There is no server available to process your request. Please try again later, or contact your system administrator if the ...
0
votes
2answers
39 views

T-SQL View issue

I'm working with a Business Objects developer to create a new report. He wants me to create a view that he can query. My problem is that I've successfully created a Query, and have verified that it ...
0
votes
1answer
153 views

Create directory using SAP BODS script

How does one create directories in a given path on Windows using SAP Business Objects Designer 4.2 Script? I got a Script with path that I'd like to create if it does not exist: $My_Path = '\\\\...
0
votes
2answers
19 views

SAP Business Objects 3.1 XI problems on regenerate structure

I have problems to refresh the structure of a table in my universe. We have added some data to a reference table which is used in universe. After checking the new data in (Oracle 11g) database, found ...
0
votes
0answers
22 views

Looping through characters in a string in BODS

i have a requirement that i have check if each alphabet/special character exist in a table in BODS dataflow. For example Value - "ABCD-" i have to then check if - "A" exists in lookup table "B" ...
0
votes
1answer
12 views

Find out what Data Security Profiles look like

A colleague has left the company. We know she implemented Data Security Profiles in our SAP BO 4.1 (unx universes) She somehow implemented row-level security. We do not know how. There are questions ...
0
votes
0answers
115 views

SAP BO - Webi reporting: report sums up measures which are hidden

I have measure value which is been used in report, I have applied some filters in report, now when i use the sum of measure values it gives the overall sum . it does not give me the sum of the values ...
0
votes
0answers
26 views

Fields that show up locally on SAP Crystal Reports develper are missing when run on server using SAP BO

I have a simple report in Crystal to develop. The business sends me the SQL, I copy and paste, and create 1 prompt. Easy. It's actually a duplicate of an existing report, but the join criteria is ...
0
votes
0answers
41 views

Access file saved as Netweaver workbook in Analysis for Office through VBA/VBScript

This is my very first question in here, forgive me if i'm not being accurate. I need to access a file saved on a Netweaver platform (Analysis for Office) trough VBA/VBScript. My goal is to access ...