Sitemap

Amicuk Programming Answers

Report using Multicube

2015-10-11   Views:2

Advertisement

Hi, I am using Multicube for one of my report, which is using two infocubes. One infocube A has characteristics x,y and keyfigure x1 and other infocube B has  characteristics x,y,z and keyfigure y1. I need to display the characeristics x,y,z values i

Hi,
I am using Multicube for one of my report, which is using two infocubes. One infocube A has characteristics x,y and keyfigure x1 and other infocube B has  characteristics x,y,z and keyfigure y1. I need to display the characeristics x,y,z values in the report along with the keyfigure x1. since there is no characeristic z in the infocube B the Report is showing two rows one has the z value and keyfigure x1 and other row z value as "not assigned" and keyfigure is y1. My requirement is to show the x,y,z values in the report along with the x1 keyfigure in a single row. If someone has worked on this type of scenario please suggest me on the solution.
Thanking you,
Raju

The replay answer
Advertisement
Hi Raj,
In your query  select constant selection on Characteristic Z.
Check this weblog
/people/prakash.darji/blog/2006/09/19/the-hidden-secret-of-constant-selection
Jaya

Go to See the other 4 answers

Report using Multicube

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

Hi, I am using Multicube for one of my report, which is using two infocubes. One infocube A has characteristics x,y and keyfigure x1 and other infocube B has  characteristics x,y,z and keyfigure y1. I need to display the characeristics x,y,z values i[More]

SAP BI INTERVIEW QUESTIONS

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

Hi Friends, I was  face some Interview. Please send answers to the questions? How many data Fields  and key fields we can create in DSO? You can overwrite key fields or Data Fields? Which up date we use in Delta queue extraction( v1 or v2 or v3) Whic[More]

Useful Interview Questions and Answere

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

Hi All Some of the Real time question. Q) Under which menu path is the Test Workbench to be found, including in earlier Releases? The menu path is: Tools - ABAP Workbench - Test - Test Workbench. Q) I want to delete a BEx query that is in Production[More]

Performance of a report over a multicube?

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

Hi, I have a report built on a multiprovider which sits over 3 ODS.This query takes a long time to run. To improve the performance...i was thinking of changing the indexes for ODS.. And i cannot think of changing the query design..cuz i dont have an[More]

Data Error in the Query/Report after selective data deletion for infocube

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

Hi Experts, Please advise what i was missing and what went wrong... I got a Query (Forecast) on a Multicube...which is based on 2 Infocubes with Aggregates... As i identified some data discrepency..yesteraday i performed selective data deleation on o[More]

Slow-Moving Item Report

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

The issue I have has been addressed in oss note(541559) but I am unable to get the solution outlined to work. The situation is I would like to show all characteristic values for 0material__PNL that we have a history of transactional data, even if the[More]

Hot
Please help. My wife's 3G connects to iTunes but my 3G won't. This makes me think the issue is with my phone. I've re-installed iTunes and updated drivers and reset the phone. I've tried all of this prior to testing the other phone and the mini I use [More]
I recently connected my Ipod to the Computer as I have done for the last year and I am now getting an error message reading: "Windows - No Disk". It then asks me to insert a disk. I cannot cancel out, continue or retry which are the three choice [More]
Hi Group, I have a query on creation of Business Partner with External BP #,ID type and Identification # (along with the Firstname,Lastname,Email, Phone & etc.,) things. the thing is that I was using a BAPI called "BAPI_BUPA_FS_CREATE_FROM_DATA&q [More]
Hi Guys. We have a project done by some employees that ported it to Solaris, these guys are left the company (but we know the project compiled on Solaris for sure) and we cannot handle the complete compilation under Solaris 10. I will drop you the st [More]
I scan a lot of documents for record keeping purposes. I set the scanner to 300 dpi, black and white. This keeps the file size down and the document is readable and printable (close to the original), and the scanning is quick. I scanned three sets of [More]
Hi All, I need to find out two reorts for below purpose: 1) Report that will give me list of all PO's which has duplicate sales order against them . 2) Report that will give me list of  all sales order which has duplicate PO's . I know there is a rep [More]
I'm running OS X 10.9.1 on a MacBook Air with the newest Java. For some reason, whenever I try to open a .jar file, it gives me a message saying "The Java JAR file... could not be launched. Check the console for possible error messages." How do [More]
Hi We are working on ECC 6.0. When we try to create Excise Invoice through J1IS for Ref doc Type MATD for Material Doc of 122 Movement Type we are getting the following error - "GL account has not been assigned for PLA AT1 in customisation" Can [More]
I am trying to use a short mp3 file as a ringtone.  So far every website has told me that all I have to do is drag the file into the "ringtones" folder that is located in the menu bar on the left side of I-tunes.  I don't have this folder.  Agai [More]
i want to move the contents on my icloud account to my mac book does anyone know how to do thisThere is no iCloud account for your computer. Only for your iDevice. If you are referring to your Time Machine backups to an external drive then please vis [More]