Creating Navigational attributes in 3.5 flow

In 3.x flow, the steps to create navigational attributes are as follows:

1) Attribute level change - Go to /nRSD1, give your navigational attribute's name-->display-->uncheck the attribute only flag and activate.

2) InfoObject level change - Go to /nRSD1, give your InfoObject name to which you want to maintain the navigational attribute --> display--> detail navigational attributes--> check navigational attribute flag against your navigational attribute and activate. Click on "Yes" wherever prompted.

3) InfoCube level change - Go to /nRSDCUBE, give your InfoCube name--> display-->click on change mode -->click on Navigational attribute --> Select yours and activate.

4) Activate Update Rules --> InfoCube--> Update Rules--> Change and activate

Tables for Process Chains Details

Find below link for BW tables
http://wiki.sdn.sap.com/wiki/display/BI/Important+Tables+in+SAP+BI+(+NW2004)

RSCOMPTLOGOT - Process Chain Component

RSEVENTCHAIN Event Chain Processing Event Table
RSEVENTHEAD Header for the event chain
RSEVENTHEADT Header for the event chain
RSPCCHAIN Process chain details

RSPCCHAINATTR Attributes for a Process Chain
RSPCCHAINEVENTS Multiple Events with Process Chains
RSPCCHAINT Texts for Chain
RSPCCOMMANDLOG System Command Execution Logs (Process Chains)
RSPCLOGCHAIN Cross-Table Log ID / Chain ID
RSPCLOGS Application Logs for the Process Chains
RSPCPROCESSLOG Logs for the Chain Runs
RSPCRUNVARIABLES Variables for Process Chains for Runtime
RSPC_MONITOR Monitor individual process chains

A Guide to the new SDN/SCN from BI perspective

Often a newbie to SCN (SAP Community Network- www.scn.sap.com ) gets quite bewildered by its vastness and becomes unable to corner to an area of interest. I have collected this information’s over a period of time and I hope it will help you to understand the new SDN in a better way, on how it is organized, how to start a discussion, how to search, and how to optimize the maximum potential.

The SCN is divided into Spaces for each technology. Here I am listing the BI spaces and the links to access it.

BI Spaces in SCN

1) Data-warehousing

http://scn.sap.com/community/data-warehousing

1a) SAP NetWeaver Business Warehouse in Data-warehousing

http://scn.sap.com/community/data-warehousing/netweaver-bw

1b) Business Content and Extractors in Data-warehousing

http://scn.sap.com/community/data-warehousing/business-content-and-extractors#

2) Business Intelligence

http://scn.sap.com/community/business-intelligence

3) SAP Business Explorer

http://scn.sap.com/community/business-explorer

4) BI Dashboards

http://scn.sap.com/community/bi-dashboards

5) Business Intelligence Old Forum (Read Only Archive)

http://scn.sap.com/community/transfer-hidden/enterprise-information-management

6)SAP Training and Education

http://scn.sap.com/community/training-and-education

6a) SAP Certification in SAP Training and Education

http://scn.sap.com/community/training-and-education/certification

Asset Types

In each of these spaces, the contents are divided in to the following ones known as Asset Types.

 

 

 

 

Discussion

Collaborative document

Article

Blog

Presentation

Wiki page

Eg. In case you want to post a question, First login, go to create a discussion, choose a space, and type in your question.

 

How to share Your Knowledge in SCN Topic Spaces

Please check this link

http://scn.sap.com/docs/DOC-18841

The new content submission (Publishing White papers)

SCN now accepts only SAP submissions and the community will submit their articles directly in the respective spaces by creating Jive docs. If you are not an SAP employee the system won't let you in, other community members should be creating documents in Jive by clicking on Create a document.

For more information

http://scn.sap.com/community/getting-started/blog/2012/03/15/where-the-content-submission-system-css-is-and-when-to-submit-articles

Points in SCN (Contributor Reputation Program)

http://scn.sap.com/docs/DOC-18475

All the above are collected to the best of my knowledge. If any one has something to addon, I request to please do so, and share with the community.

"The more you share your knowledge, the more you get"

 

My tryst with PMP Certification

Hi all,

I know its a little late to bring up this!!! and the fact that this blog is all bout SAP BI..but just in case any of you are contemplating to be PMP certified...this one is for you.

I passed my PMP exam on August 2010.  I have been on and off the pmzilla forum learning a lot from others questions and lessons learned.
I started preparing in the month of May and have been consistent in preparing for 2hrs per day. The materials I used were the PMBOK 4th edition, Head First PMP, PMP: Project Management Professional Exam Study Guide by Kim Heldman, and Rita Mulcahy's PMP Exam Preparation 6th edition.
I started off with the PMBOK, 4th edition.I read through it the first time just to get an idea of what to expect, that itself took a week to finish! Then I joined the above site and began reading how others prepared for the exam. This brought me to the Rita Mulcahy’s PMP book. This was really helpful in getting the basics right. Then I followed a pattern of reading a chapter from PMBOK, then the same chapter from Rita’s PMP, Head first PMP, and then Kim Heldman’s PMP guide. This helped me getting the foundation strong, I analyzed situations and found the gaps I had in my PM knowledge. I took notes of important points from these books. I found Kim Heldman’s PMP guide organized differently, which made it hard to sort according to the KA, so used to just skim through it and answer the chapter end questions. On the whole, I found Head First PMP book had simple explanation and that Rita’s PMP followed a more comprehensive approach. I used Rita Mulcahy’s Fastrack SW too. After this I started taking online tests from different sites like
www.preparepm.com
www.pm-abc.com
www.passionatepm.com
www.simplilearn.com
www.headfirstlabs.com/PMP/pmp_exam/v1/quiz.html
http://www.voightps.de/Free_PMP_Exam.asp
www.oliverlehmann.com/
I used to take notes on all the incorrect answers I got and used to analyze why I got it wrong. I used to put in extra hours during weekends. So by July I finished all this and began reading PMBOK once more, this time I prepared an ITTO dump, using mnemonics. I tried this site and found it to be quite good. Thanks Harwinder!www.monkibo.com/pmp-exam-itto-trainer/index.html.
Along with this I used to go through all the notes I prepared and follow this forum and www.deepfriedbrainpmp.com
A week to my scheduled exam I did the pmp exam from www.pmstudy.com and also went through the Code of Ethics and Professional Conduct by PMI. I found the pmstudy’s exam closer to the actual exam.
My scores were between 75% and 82%.The whole preparation got me an idea that the exam was going to be tough.
The day before the exam, I just went through the ITTO dump and slept early and tight. I didn’t prepare the PMBOK page 43 and formulas dump as after all this preparation they were crystal clear to me.
Exam Day
I got the afternoon slot, so just went through my study notes and reached the center 30 min ahead. There was a security check (not even in airports have I seen something of this extent!), asked to remove my watch, and keep my belongings in a locker. The locker key and primary ID were allowed inside.I was given 2 sheets of paper and 2 pencils.I was given a brief of the exam and that it was video and audio recorded. When the 15 min tutorial started I wrote the dump within 10 min and went through the tutorial and started the exam. I was relieved to see that the exam was not tough as it was projected to be, not much of paragraph questions, only simple problems to solve. More questions were from quality, risk, change requests, and ITTO’s. After 50 questions I was sure to make it. I finished the exam within 3 hrs, with 4 questions marked for review. The rest of the time I spent reviewing all questions, changed a couple of answers and hit the end button. I was asked to finish a survey and then voila!!! The words I was dreaming all the way..Congratulations !!!.. There were some more sentences too, which I don't remember now..Well at that point, nothing else mattered! I thanked God.The freaky Friday is nothing but a mythJ
When I came out I was given a score report.I scored proficient in 3 and moderately proficient in others.
A few people I would like to thank….Harwinder and chandraR for their wonderful explanations. Great work guys!!My family, friends, and most importantly God!!!
Thank you all from the bottom of my heart…..!

Error: Setup Table for SD not getting deleted

Error: Need to delete the setup table for SD module , in LBWG, upon clicking the execute button , a confirmation window opens up asking "Data will be lost , Do u want to delete the restructure tables" , I click on YES and after that there is no further status message (that whether the delete was sucessfull or not). Now when i go to RSA3 and test the extraction( for 2LIS_11_VAITM) , it still shows some records . indicating that the setup table has not been deleted

Solution:
1. Call T/A SE14 --> Enter table name MC11VA0ITMSETUP -->Select radio button "tables" --> click on Edit -->Select processing type "Background" --> Click on "Activate and Adjust database".
2. Here before performing the Activate and Adjust database function -- first try to check the data base object (click on check button and select database object --ok) if every thing is ok then proceed with the above steps.
3. Next try to delete the setup tables and check.

Also check if the data source is active or not before deleting the setup tables.