Sitemap

Amicuk Programming Answers

Process & optimize issue with timeid

2015-10-11   Views:0

Advertisement

Hi, I work on script logics with BPC 7.0 xls2007 sql2005. I need to process my application but I have this issue message :    - Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_tblFactEPS, Column: TIMEID, Value: 100000

Hi,
I work on script logics with BPC 7.0 xls2007 sql2005.
I need to process my application but I have this issue message :
   - Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_tblFactEPS, Column: TIMEID, Value: 10000022.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
Errors in the OLAP storage engine: An error occurred while processing the 'EPS' partition of the 'EPS' measure group for the 'EPS' cube from the DEV database.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
Internal error: The operation terminated unsuccessfully
The timid value 10000022 correspond to 2010.TOTAL.
So I saw the dbo_tblFactEPS table with :
Select * from tblfactEPS where TIMEID not in (select timeid from mbrTIME)
But my selection is empty...
Moreover, I can't process my time dimension.
Can you help me ?
Regards,
Morgann

The replay answer
Advertisement
2010.Total is not a base member and normally you should not have something like that into your fact table.
Into fact table you must have just base members.
your selection is not completed. It has to be
Select * from tblfactEPS where TIMEID not in (select timeid from mbrTIME where calc = 'N')
If you will do that actually you will see records.
Kind Regards
Sorin Radulescu

Go to See the other 5 answers

Process & optimize issue with timeid

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

Hi, I work on script logics with BPC 7.0 xls2007 sql2005. I need to process my application but I have this issue message :    - Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_tblFactEPS, Column: TIMEID, Value: 100000[More]

SNP Optimizer Issue

Category:DefaultRelease time:-0001-11-30Views:130

Hi Experts, We are working on SNP Optimization scenario with Transportation, Procurement, Strorage and penalty Cost. Our business process trading industry (we procure and sell). We maintained Optmizaion profile with linear and Primal simplex Algorith[More]

Outbound BPEL Process deployment Issue in SOA (binding.jca-12600)

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

Hi, I have Designed an Outbound BPEL Process for Siebel CRM Service Integration using Jdeveloper (11.1.1.3.0). After that I am facing the deployment issue of this application in SOA suite (11.1.1.6.0). Following is the deployment.log status in jdevel[More]

SAP BI 7 - Background process performance Issue

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

This question is about efficiency of dialog process compared to inefficiency of the background process and I want suggestions from SAP Basis/BI experts on this. We have observed that our background processes on BI server are not running as efficientl[More]

Oracle 11g on Linux : Query Optimization issue

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

Hi guru, I am facing one query optimization related problem in group by query Table (10 million Records) Product(ProductId number,ProductName varchar(100),CategoryId VARCHAR2(38),SubCategoryId VARCHAR2(38)) Index create index idxCategory on Product ([More]

Supplier Process chain issue

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

Hello, We loaded supplier(LSUPPLIER) from ECC to SPM. The data got loaded to PSA and info objects. But when I release the supplier load, the process chain is running for last 7 hours. We had same issue in QA where it ran for almot 2 days and even aft[More]

Adobe Acrobat Distiller Process. Issue with Font(L0420P not found, using courier)

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

Hi Everybody, We are working for upgrade activities, which involves moving applications from Windows 2000 to Windows 2003 Servers. My applications uses Adobe Acrobat distiller, which is also getting upgraded along with the server from Adobe 4.0 to 5.[More]

Material Availability Check in Process Order Issue

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

Guys, I need some help in understanding the folowing issue: I have a FG and 2 components.I created a process order and tried to release the order. Automatic availability check is done and a dailog box appeared to list out the missing parts. Missing p[More]

Process Chain Issue

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

Hi Gurus When i am executing the Process chain which contains two loads(two local chain)- Master data and transaction load. After trigger the master variant, it goes to the  Master data local chain, but Its showing the yellow status for long time. Bu[More]

Process key issue in MM

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

Hi All, I am working on 0PUR_C01 cube and theDS is 2lis_02_itm.i am facing a issue with the process key ,only process keys 2 and 3 are coming into the BI system even though process key 1 and others are also there in the source. i have maintained the[More]

Process chains issue:very urgent

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

Hi All, This issue is related to process chains.Last weekend our Basis team changed the BW PRD from BWBPRD to BWBPRD1.The process chains were schedlued previously on BWBPRD, so after the server change none of the process chains were triggered. We hav[More]

Hot
I have searched the forum for similar issues, and have posed one or two questions, but I am struggling to get a clear direction as to how to post quiz results to an internal server automatically (including user variables), without the name/email dial [More]
Hi All, I am facing an issue with Hyperion Planning 11.1.2 which was working till yesterday. When i login into the and go to navigate --> Administor --> Dimension Library i am getting an error which iam not able to understand. kindly help me out. i [More]
I have a solid red circle on the phone icon at the bottom of my home screen.I Get a notification message come up on my home screen telling me that i have a new voicemail mesage.      When i dial into voicemail it tells me there are no messages.I Have [More]
what operating system do I need to use the newest Airport Extreme? I am running on 10.6.8 but I think I need 10.7.5.  Is it worthwhile to go with the latest Mavericks?1. You should check if Mavericks is supported on your Mac - OS X Mavericks - Techni [More]
First, thanks in advance for reading this request. Second, the situation: I am using an array of clusters for process control. The cluster contains a boolean, a typedef ring control, and two numeric controls (doubles). Depending upon the user-request [More]
I had two videos saved on my Sprint Curve 9330 that played with OS 5.  After installing OS 6, I now get an error message that states, "The video portion of the media being played uses an unsupported format."  The sound from the video plays, but, [More]
I updated my iMac yesterday to check out this new feature, but I can't seem to figure out how it works. Can anyone tell me how to view my wishlist from my music library. I restarted my computer, but that didn't work either. I'm obviously missing some [More]
Hi all, Is there anyway a user can control the commpression rate in Mavericks. I previously used Stuffit Expander and the built in compression in Entourage 2008. As Mavericks has its own compression utility I cannot find where you can control the rat [More]
Hi B2B gurus, I am Using EDI X12 over internet. Our suppliers processing inbound transactions to us,After receiving from B2B its storing in IP_IN_Queue, The documents which we are sending it storing in IP_OUT_Queue. We want to see the data in in IP_I [More]
Hello Folks, I have added the field in the DB table in DEV server but it wont reflect on Quality server. I cheked it on DEV, it is showing there. There is no issue with the SM30 also. But still it wont reflect on quality. So I deleted the existing TM [More]