Sitemap

Amicuk Programming Answers

Wrong data when i create a report on infoset in BI 7.0

2015-10-11   Views:1

Advertisement

Customer No has the master data(C100,C200,C300,C400) and C300 and C400 are not performed any transaction in the cube. Created a infoset with left outer join on infoobject (Customer No) and the Infocube(which has the transactions done by the Customer)

Customer No has the master data(C100,C200,C300,C400) and C300 and C400 are not performed any transaction in the cube.
Created a infoset with left outer join on infoobject (Customer No) and the Infocube(which has the transactions done by the Customer)
i kept the Customer No in the rows and the Netsales in the column of the report in BI 7.0 query desiner and when i run the query i got the result as C100 and C200 only  not C100,C200,C300,C400
But the result should show C100,C200,C300 And C400
Please clarify me what could be the problem ?

The replay answer
Advertisement
Did you select Customer from the cube or the Infoobject for Infoset?

Go to See the other 2 answers

Wrong data when i create a report on infoset in BI 7.0

Category:DefaultRelease time:2015-10-11Views:130

Customer No has the master data(C100,C200,C300,C400) and C300 and C400 are not performed any transaction in the cube. Created a infoset with left outer join on infoobject (Customer No) and the Infocube(which has the transactions done by the Customer)[More]

Is it possible to use an XML Data Template to create a report in APEX?

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have created an XML Data Template in BI Publisher passing one parameter and running two queries, then created an RTF Document Template to present the data. I can create a nice report in BI Publisher using the two elements. I have used RTF Docum[More]

Creating a Report from ECC

Category:DefaultRelease time:2015-10-11Views:130

Can we create a report directly from ECC (R/3) instead of BW Cude or BW Query using WebI or Crystal Reports??Thanks for the response. So, to build report directly from ECC (R/3 Tables), Crystal Report is the solution?? you mentioned about InfoSet als[More]

How to create a report to bring all data from two different Info providers

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I have a peculier problem while creating a report. I have two custom info providers one DSO and another Cube. There are only two common fields between these two Info providers . I need to create a report such that the report displays all the[More]

How to create APEX report from data in PLSQL table

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a procedure that is creating/inserting records into multidimensional pslql table. I want to create a report and graph based on the data stored in plsql table. Can someone please advice how to can I select this data in apex OR point me to a[More]

APEX4: How to create a report whose data is based on user input date fields

Category:DefaultRelease time:2015-10-11Views:130

Using Apex 4 I've to create a report that allows the user to input two date and shows a report between the date range. How can I do this? Thank you.This has nothing to do with apex 4.0. If you create a report using this query: SELECT *   FROM emp WHE[More]

How to create a report with survey data

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I need to create a report with survey data in below format. Can anyone help me how to display the summary in this format. SwapnaHi Swapna, According to your description, you want to create a report with survey data and display the summary. Re[More]

How to create a report without any data

Category:DefaultRelease time:2015-10-11Views:130

HI All, <BR> Can anyone help me in writing a report without any data. I want to create a report with list of memebers from a dimension where UDA is "My UDA". I wrote a report "<UDA(CHANNEL,'My UDA')" but this fetches me data t[More]

How to create a report with data using the Crystal Reports for Java SDK

Category:DefaultRelease time:2015-10-11Views:130

Hi, How do I create a report with data that can be displayed via the Crystal Report for Java SDK and the Viewers API? I am writing my own report designer, and would like to use the Crystal Runtime Engine to display my report in DHTML, PDF, and Excel[More]

How to create a report using XML data source from Crystal Report Designer

Category:DefaultRelease time:2015-10-11Views:130

Hi, Iu2019m having Crystal Report Designer XI R2 SP4. Iu2019m trying to create a report using XML data source stored on disk. This is a customer order report and the xml is structured in such a way that it has an order details header part (master) an[More]

Problem when creating a Report with a schduled date

Category:DefaultRelease time:2015-10-11Views:130

When I tried to create a report with a Schedule (any option except NOW) I get the error of "First Report Occur Date should be after or equal to Current Date" unless I use a date of 2012-10-01 or later in the First report occurs on field.  Today'[More]

Hot
I have a 13" MacBook. I also have a nice 19" Samsung flat screen monitor lying around here. Since my laptop sees most of its duty on a table during the summer (no school), I'm thinking of getting the monitor and a keyboard and hooking it up, eve [More]
Hi, Implementing Kerberos as the Desktop Single Signon Solution Environment : Peoplesoft OS : Redhat Linux webserver: Weblogic 10.3.4 appserver : tuxedo 10gr3 While doing this implementation I was able to complete it successfully with the JDK linux h [More]
Just got a new external display, and can't get it to work with my MBP. I tried it via the mini display port and also via the HDMI connection. Then I tried to use my flatscreen tv just to test things out via HDMI and now that doesn't work either, I've [More]
Hello!   I am doing report with VC. Now I want to print data ,The system action "print" can not print all data,only a page in the table  can be printed. Are there any ways to finishe the print function,Can you help me? Thank you very much!See th [More]
I'll try to keep this short and sweet. I have some footage on a Sony HD cam.  When I connect it to the mac, the drive appears just fine.  When I go to "log and transfer" it no longer begins loading itself.  When I try to manually select the disk [More]
Hi, I was forced to uninstall LV 8.2.1 and reinstall it. When I'm reinstalling LV 8.2.1 I get an error message Error 1301. Cannot create file ". A directory with the same name already exists. Cancel the install and try installing to a different locat [More]
Hello Geniuses, I have spent hours trying to find the year and or model of my Mac Pro 2 x 3 GHz Quad-Core Intel Xeon. The search is not for the faint of heart.  I running Lion and want to know if I can upgrade to Mountain Lion.  I had a similar exper [More]
Hello, I have an issue on pricing determination with product hierarchy. I created product hierarchy as following, level1 - A0001 level2 - A0001B0001 level3 - A0001B0001C0001 Then, assigned A0001B0001C0001 to material D in material master. I created c [More]
I am awaiting my 32GB iPad, and want to set things up to load photos in albums. I have a win XP Pro machine, not a mac, thus no iPhoto on the computer, just the iPad. How can I group my individual photos into albums to load onto the iPad?Just create [More]
Hi, I managed to install Windows on a partition of a secondary hard drive with Winclone, but I am unable to boot on it. Now when i choose windows as startup device i get the "No bootable device --- insert boot disk and press any key" error. I pl [More]