(TR0112) There isn't enough memory available

Error:
(TR0112) There isn't enough memory available.

Reason:
"Enable Mutli-Processing" enabled on datasources and the addition of the new datasource appears to push the limitations of this feature based on the size of the data being pulled.
Remove multi-processing from datasources


1. Open the model in Transformer
2. Right click the datasource and select "properties"
3. Click on the General tab
4. Uncheck "enable multi-processing" and click OK
5. Repeat steps 2 through 4 for all data source entries
6. Test / Build


Also ensure that there are enough system resources available when building the cube. This includes plenty of free memory, diskspace, and processor time. For example, if your database is using up 90% of the memory while you attempt to launch rsserver to build cubes, the cube build will fail at some point due to lack of memory available. Lack of memory in this case can also seen via monitoring the syslog (on unix system only) file.

TR1907 Transformer cannot gain access to database

When a cube is automated to rebuild on a regular basis, transformer fails to create the cube due to the failed authentication. Transformer prompts for user password even if the prompt for password box is unchecked in the Signon Property Sheet and Include Access Manager auto-access in the model is checked in the authentication tab of Model Property Sheet.
Error Details:
(TR1907) Transformer can't gain access to database 'Database Name' with signon information 'username'. [->Cancel] PowerPlay Transformer
Reason:
The Database signon is not recognized by Transformer via Access Manager due to an incorrect database name. Database name specified within transformer needs to be exactly the same as the one set up within Access Manager. This is also case sensitive.

Use Access Manager to record the database authentication and set the auto-access to access manager's signon. Cognos common signons are set to flown from Access Manager user class as well as the database signon

Steps:

1. Create the data source in Access Manager Admin Console
2. Add user signos into the user class Administrator
3. Uncheck the box against Prompt for Password in the user signon property sheet
4. Within datasource property sheet, specify the datasource name, which should be exactly the same as the one in Access Manager. The datasource name is case sensitive.
5. Activate "Include Access Manager auto-access in the model" from Authentication tab of the Model Property Sheet

Interesting article……

Interesting article……

What killed Ranjan Das and Lessons for Corporate India

A month ago, many of us heard about the sad demise of Ranjan Das from Bandra, Mumbai. Ranjan, just 42 years of age, was the CEO of SAP-Indian Subcontinent, the youngest CEO of an MNC in India. He was very active in sports, was a fitness freak and a marathon runner. It was common to see him run on Bandra's Carter Road. Just after Diwali, on 21st Oct, he returned home from his gym after a workout, collapsed with a massive heart attack and died. He is survived by his wife and two very young kids.

It was certainly a wake-up call for corporate India. However, it was even more disastrous for runners amongst us. Since Ranjan was an avid marathoner (in Feb 09, he ran Chennai Marathon at the same time some of us were running Pondicherry Marathon 180 km away), the question came as to why an exceptionally active, athletic person succumb to heart attack at 42 years of age.

Was it the stress?
A couple of you called me asking about the reasons. While Ranjan had mentioned that he faced a lot of stress, that is a common element in most of our lives. We used to think that by being fit, one can conquer the bad effects of stress. So I doubted if the cause was stress.

The Real Reason
However, everyone missed out a small line in the reports that Ranjan used to make do with 4-5 hours of sleep. This is an earlier interview of Ranjan on NDTV in the program 'Boss' Day Out':
http://connect.in.com/ranjan-das/play-video-boss-day-out-ranjan-das-of-sap-india-229111-807ecfcf1ad966036c289b3ba6c376f2530d7484.html < http://connect.in.com/ranjan-das/play-video-boss-day-out-ranjan-das-of-sap-india-229111-807ecfcf1ad966036c289b3ba6c376f2530d7484.html >
Here he himself admits that he would love to get more sleep (and that he was not proud of his ability to manage without sleep, contrary to what others extolled).

The Evidence
Last week, I was working with a well-known cardiologist on the subject of ‘Heart Disease caused by Lack of Sleep’. While I cannot share the video nor the slides because of confidentiality reasons, I have distilled the key points below in the hope it will save some of our lives.

Some Excerpts:

· Short sleep duration (<5> compared to those who slept longer than 6 hours per night. Paper published in 2009.
As you know, high BP kills.

· Young people (25-49 years of age) are twice as likely to get high BP if they sleep less. Paper published in 2006.

· Individuals who slept less than 5 hours a night had a 3-fold increased risk of heart attacks .. Paper published in 1999.

· Complete and partial lack of sleep increased the blood concentrations of High sensitivity C-Reactive Protein (hs-cRP), the strongest predictor of heart attacks. Even after getting adequate sleep later, the levels stayed high!!

· Just one night of sleep loss increases very toxic substances in body such as Interleukin-6 (IL-6), Tumour Necrosis Factor-Alpha (TNF-alpha) and C-reactive protein (cRP). They increase risks of many medical conditions, including cancer, arthritis and heart disease . Paper published in 2004.

· Sleeping for <=5 hours per night leads to 39% increase in heart disease. Sleeping for <=6 hours per night leads to 18% increase in heart disease. Paper published in 2006.

Ideal Sleep
For lack of space, I cannot explain here the ideal sleep architecture. But in brief, sleep is composed of two stages: REM (Rapid Eye Movement) and non-REM. The former helps in mental consolidation while the latter helps in physical repair and rebuilding . During the night, you alternate between REM and non-REM stages 4-5 times.

The earlier part of sleep is mostly non-REM. During that period, your pituitary gland releases growth hormones that repair your body. The latter part of sleep is more and more REM type.

For you to be mentally alert during the day, the latter part of sleep is more important. No wonder when you wake up with an alarm clock after 5-6 hours of sleep , you are mentally irritable throughout the day ( lack of REM sleep ). And if you have slept for less than 5 hours , your body is in a complete physical mess ( lack of non-REM sleep), you are tired throughout the day, moving like a zombie and your immunity is way down (I’ve been there, done that L )

Finally, as long-distance runners, you need an hour of extra sleep to repair the running related damage.

If you want to know if you are getting adequate sleep , take Epworth Sleepiness Test below.



Interpretation : Score of 0-9 is considered normal while 10 and above abnormal. Many a times, I have clocked 21 out the maximum possible 24, the only saving grace being the last situation, since I don’t like to drive (maybe, I should ask my driver to answer that line J )

In conclusion:

Barring stress control, Ranjan Das did everything right: eating proper food, exercising (marathoning!), maintaining proper weight. But he missed getting proper and adequate sleep, minimum 7 hours. In my opinion, that killed him.
If you are not getting enough sleep (7 hours), you are playing with fire, even if you have low stress.

I always took pride in my ability to work 50 hours at a stretch whenever the situation warranted. But I was so spooked after seeing the scientific evidence last week that since Saturday night, I ensure I do not even set the alarm clock under 7 hours. Now, that is a nice excuse to get some more sleep. J

Unfortunately, Ranjan Das is not alone when it comes to missing sleep. Many of us are doing exactly the same, perhaps out of ignorance.

Flow of Data in Cognos Powerpaly Transformer 7.4

Use Transformer to create structured models from various data sources that you then distribute as multidimensional PowerCubes.
You begin by assessing your source data and planning how to organize it to support the types of
business analysis that are important to you. You then build a model that specifies the location of
this data, and the way you want Transformer to restructure it. Finally, you create a PowerCube to distribute to your PowerPlay Enterprise Server administrator or to your PowerPlay users, who can then create reports to distribute to other PowerPlay or Upfront users.

Everybody loves Hanuman by Dr. Devdutt Pattanaik

Dr. Devdutt Pattanaik written this article . Its an amazing must read.........

Published in Corporate Dossier, Economic Times supplement, 4 April 2008

Hanuman plays an important role in the Ramayan, yet in the epic itself, he does not hold any great position. He is just one of the many monkeys Ram encounters in the forest. He is not Sugriva, leader of the monkey troop. He is not Angad, who is told to lead the band of monkeys searching for Sita. He is not Jambavan, the bear or Nila, the monkey, who are given the responsibility of building the bridge. He is projected as an obedient follower who, through his intelligence, strength and courage, wins the admiration of Ram and emerges as one of the most revered characters of the tale and a god in his own right. But at no point does Hanuman make any attempt to steal anyone’s glory; while in his own temple he stands powerful with mountain in hand and feet on a demon, in Ram’s temple he is most content sitting at the feet of his master, hands in supplication.

Who would not want a Hanuman in his team? One who is very good at his work, one who will do whatever he is told to do, one who will never seek either reward or recognition and one who finds validation in obeying his master.

If we go to Raju’s auto repair shop, we will find that all the work is done by his Hanuman: Amol, a young boy, who has been working with Raju for three years. Amol is a natural, able to fix the most complex of problems. Raju knows he can totally rely on Amol. No job is too big or too small for Amol. He is as happy changing a tyre, as he is fixing the brakes. He does not boss over the juniors and does not feel slighted if the seniors ask him to fetch tea. If there is a problem that eludes a standard solution, everyone knows that leave it to Amol – he will, like Hanuman crossing the sea, find a way.

Yes, it matters greatly to have a Hanuman in our team. One who will not question you. One who will do exactly what you tell him to do. One who delivers no matter what the odds. One who is loyal and devoted. But is that really good?

The following is a folk story of Hanuman: Hanuman once narrated the entire Ramayan to his mother, Anjani. After the narration, an impressed Anjani sought a clarification. “You are so strong that with a flick of a tail you could have destroyed the whole of Lanka, killed Ravan and rescued Sita. Why did you not do so? So much effort and time would have been saved – you would not have had to build a bridge to Lanka, you could have avoided the war. Why did you not do that?”

Hanuman replied, “Because Ram never asked me to.”

And suddenly we wonder if this was opportunity lost. Hanuman was asked to discover Sita’s location; he did that. Hanuman was asked to fetch the mountain of herbs that would save Lakshmana’s life; he did that. No one asked him to destroy the Rakshasas and rescue Sita. Do he did not do that. One common explanation given for why Ram never asked Hanuman to kill Ravan and rescue Sita is that it was Ram’s duty to rescue Sita, not Hanuman’s. Ramayan is about Ram, not Hanuman. But it is not so in the corporate world; the story is about the entire organization, not just about the leaders.

In the entire epic, Hanuman proves his capability time and time again. On his way to find Sita, he displays his extraordinary power (crosses the ocean), brain (outwits the snake-demon Surasa), brawn (kills Simhika) and integrity (not resting on Mandara mountain). And yet, while everyone admires this, no one seems eager to take full advantage of it. Was this refusal to take advantage of Hanuman’s abilities a divine decision or merely a oversight? Is the same being done in the corporate world?

Yes, Raju loves Amol’s work. Yes, Raju admires Amol’s work. But is Raju harnessing the full potential of Amol? Is his contentment with Amol’s obedience preventing him from seeing all that Amol can do, proactively, creatively, independently, if he is given the freedom to do so? Ask Raju and he will say, “But I don’t stop Amol from doing anything.” He does not stop Amol from doing anything, but he does not encourage Amol from doing something either.

The greatest danger of having Hanumans in our team is that his actions are limited by our directions. Maybe we fear that if Hanuman thinks for himself, there will be chaos – he is a monkey after all. Maybe we fear that he will overshadow us. Hence, ultimately, only we decide the goals, we define the vision, we declare the mission and state the objective. Our Hanuman will help you realize all this. But, maybe, the goals could have been greater and grander, if we had let Hanuman do more than merely obey.

Amol once had given Raju a suggestion. “Sir, if we park our cars perpendicular to the wall rather than parallel we can keep more cars in the garage?” Raju ignored this suggestion. “Do you work,” he snapped at Amol without giving his words much thought. But the message he implicitly gave Amol was that – ‘I only want your obedience, not your intelligence.’ Amol immediately complied. And that marked the end of Amol’s creativity that would have perhaps made Raju’s auto repair shop a much greater success.

This is the danger of over compliance and extreme obedience. We prevent followers from thinking and contributing. It makes business sense therefore to take a closer look at the Hanumans in our team; we just might find in their hearts a Ram waiting to be coaxed out.

http://devdutt.com/everybody-loves-hanuman

IBM Cognos Express Webminar

Join unveil IBM Cognos Express – the first and only integrated, one-stop BI and planning solution purpose-built and priced for midsize companies.
http://www-01.ibm.com/software/data/cognos/cognos-express/index.html?mc=-eb_ibm_hp
Thanks and regards
Abhishek

IBM Cognos Express Webminar

Join unveil IBM Cognos Express – the first and only integrated, one-stop BI and planning solution purpose-built and priced for midsize companies.
http://www-01.ibm.com/software/data/cognos/cognos-express/index.html?mc=-eb_ibm_hp
Thanks and regards
Abhishek