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
basically it's been a problem for a while now my sennheiser headphones are not clicking in correctly and are popping out at every movement causing it to pause my music, (very annoying) but it works fine if i hold it in, but can't do this all the time [More]
I am having a problem when my ipod is connected to my computer. It connects to itunes, but when I click on the ipod or playlists in the ipod everything is greyed out and I can not click on it. I am not able to drag new downloaded songs into any of my [More]
I've been having a problem with watching videos such as video podcasts in itunes as of late. I've been getting the audio, but all that shows up for the video is multicolored static. I was able to views these files before in itunes, but it is just rec [More]
I lost my iTunes and all my music when my laptop died, but managed somehow to get it all back onto my new laptop - none of my music is purchased though iTunes but downloaded separately or from CDs. However when I sync my iPod it doesn't actually chan [More]
I have the following XSD sample: <?xml version="1.0" encoding="UTF-8"?> <xsd:schema targetNamespace="http://www.irs.gov/efile" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.irs.gov/efi [More]
hi, I have installed apex 2.2.1. Now it says: The structure of the link to the Application Express administration services is as follows: http://host:port/pls/apex/apex_admin from where i can get this port number? kindly help.. Regards, Saad.hi ben, [More]
Hi! We have Sql Server installed on Windows 8.1 PC and on this PC, we have multiple Users with Microsoft email accounts. As we just migrated from WIndows 7 to WIndows 8, I am finding it challenging to grant permissions to every User with an account o [More]
hi,       durinf transaction MIRO, when we hit pricing procedures then i want the standard variable for PO(ekko/ekpo) flowing in the pricing procedure so that i can use it in pricing procedure. Thanks, GauravHi gibi, You can check both PO price and c [More]
ı did  down loaded the turkish version of Ps trial product, I want to delete it and download the english version, how can I do, can I do it With my same adobe ID?I did "delete" ☹((( Windows Posta cihazından gönderildi Kimden: station_two Gönderm [More]
Hi, When i am executing planning layout i am getting following error. "You have no authorization for the requested data". i am able to execute actual layout,in actual layout having the data but while executing plan layout it's getting messages.i [More]