SAP Design Studio 1.6, dynamic forms
I am new to Design Studio and SAP-World. In my project I am designing a User-Interface to generate Reports at the end. I have a Tab-Panel, within this I need to preselect the number of queries to the database and depending on that dynamic numbers of forms should show up.
For example: User A chooses a country (tabstrip) and needs different reports from different cities so he chooses in a dropdown-menue 4 as number of reports and a equal number of forms(all have the same design) pop-up. After all form fields filled up, User A presses Start and gets his reports.
Do you have any ideas how to solve? Thanks for your knowledge and creativity in advance!
See also questions close to this topic
- Connect Crystal Rerport with VB.net and Hana Database
Not able to pass service URL in the OModel object. Not getting the table data in the SAPUI5 app
Grettings! I am facing problem while creating the SAPUI5 application.
I created an oData service, it is working fine getting the metadata as well as the json format. But when I am trying to pass that service URL in the oModel object, I am not able to retrieve the table data in the UI app yet there is data in the table. I am not able to figure out why it is not fetching the table data.
The service i passed in the oModel is as follows :
Please guide me through this query.
It would be really helpful if I can get a solution to this problem.
Thanks in advance.
#OVERFLOW in SAP Reporting
I am pulling reports as an excel file from WebI and all the cells have #OVERFLOW. I am fairly new into SAPHana and WebI, and having to self-teach navigating the system. Could anyone please ELI5(Explain like I'm 5) on how to not receive that error in the excel reports?
How to set value of variable from script task for data flow task
I am new to SSIS and creating package for IDL (incremental data load) for multiple tables.
My package has Execute SQL TASK and it is working when I set value of variable from script task But when I try to set value of variable from script task for data flow (oldedb source ) It is not working e.g
My SSIS package:
Script task to loop through schema for table and set SourceTable=TableName.
- oledb source (use SourceTable)
- lookup (Lookup no match out put)
- Oldedb destination
Any idea why??
How to pass single parameter, multiple parameter or null to a report
I am trying to create a report from a query that returns a list of transactions which contains the following:
The query would be simply the following:
Select Trans_Id, Trans_Type, date, amount, status, client from table.
What I want to do is to add all the columns as parameters for the report, allowing the user to fill one parameter or more than one parameter and based on that will return the data or fill nothing so it will return everything. It's like activating a WHERE condition if a parameter is filled otherwise return everything.
Any help would be greatly appreciated
Java developer vs Business Intelligence developer, which one to choose?
Im placed in college for java developer in some company and business intelligence developer in some another company. I don't understand which one to choose?
Please suggest me and provide pros and cons. Thank you..!
SAP BusinessObjects BI 4.1.5 function that list all the tables and all the fields used in each report
I am looking for an SAP BusinessObjects BI 4.1.5 function that list all the tables and all the fields used in each report we have. We have hundreds of reports.
The result of the function would list all the Reports, Tables used in each report, Fields in each table, Type, Description, and Value.
Is there a tool or function that can do this quick and painlessly?
We are on SAP BusinessObjects BI Platform 4.1 Support Pack 5 Patch 13 Version: 18.104.22.1689.
SI_PROCESSINFO.SI_WEBI_PROMPTS via RESTful sdk
I need to get all prompts from repo. I use this query in the query builder:
select * From CI_INFOOBJECTS where SI_KIND = 'Webi' and SI_PROCESSINFO.SI_HAS_PROMPTS = 1
It works fine. Browser shows prompts in
SI_WEBI_PROMPTSsection. But when I try to use this query in my c# app via RESTful sdk:
string body = @" <attrs xmlns='http://www.sap.com/rws/bip'> <attr name = 'query' type = 'string'> select * From CI_INFOOBJECTS where SI_KIND = 'Webi' and SI_PROCESSINFO.SI_HAS_PROMPTS = 1 </attr> </attrs>";
It returns only
SI_WEBI_DOC_PROPERTIES. There is no
SI_WEBI_PROMPTS. I tried also to set selected field directly. It doesn't make sense...
select SI_PROCESSINFO.SI_WEBI_PROMPTS From CI_INFOOBJECTS where SI_KIND = 'Webi' and SI_PROCESSINFO.SI_HAS_PROMPTS = 1
However I see that this field is accessible. The next query returns data but just common fields... Pay attention to
string body = $@" <attrs xmlns='http://www.sap.com/rws/bip'> <attr name = 'query' type = 'string'> select * From CI_INFOOBJECTS where SI_KIND = 'Webi' and SI_PROCESSINFO.SI_HAS_PROMPTS = 1 and SI_PROCESSINFO.SI_WEBI_PROMPTS is not null </attr> </attrs>";
SAP Data Services and Python - how to install a library? (PIP missing?)
Data Services ETL tool allows to work with python code. But the installation comes with the basic installation. So no pandas , etc. modules standard available.
Does anybody know how to add python libs to the SAP data services tool?
In my normal python environment this would be done by a 'pip install…'
But with data services this is less clear (no pip available) :(
I'm able to find the python installation within the data services folder. And this also contains a 'site-packages' folder. But not clear how to add packages in it?
Many thanks for the help!