Producing error while creating package

[inu]

Hi bro
For the simplification of report generation, I created one database layer, and one presentation layer, after relationship/joining in database layer. I created some Query subjects inside the presentation layer for the sake of convenience in generating reports. and dropped query items into those query subjects from database layer.
     
      But while i generate package , it produces errors in presentation layer, i m not able to find the errors. where i did mistake.
I think , i dont have the idea about what query items should be kept in which query subjects, or it may be the issue of fact and dimension query items, that i badly and blindly mixed and messed up all the things in presentation layer.
      please give me some idea for keeping the fact , identifier, attribute query items into which query subjects. i need only some hints. Even i have saved my database layer and presentation layer into the following link. please go through this, i will be highly obliged to you

   
http://shrib.com/frameworkmanager

best regards
inam

[bdbits]

What errors? It's a little difficult to make any suggestions without knowing the problem.

[inu]

Hi
If i create package without presentation layer it gets success to be created and published the package. I find no errors.

But when i create package after creating presentation layer, package created but The errors come as " There are errors in publishing the package".

Becoz of this reason  i m not able to publish the pakcage. i have saved my database layer cum presentation layer including their data that i created, in the following  link, please go through this, check it , i will be highly obliged to you.

http://shrib.com/frameworkmanager

Best Regards
Inam

[bdbits]

Your link is just a list of query subjects and attribute names. While I see nothing wrong with those, it is not likely related to whatever error you are getting.

In FM, go to menu item Project > Verify Model, check all of the check boxes, then click Verify Model. If this comes back with "No issues detected during model verification." then the problem is probably not in the model. If you get any other messages, resolve whatever is causing them until you get the "No issues" message. Then try republishing.

If the model verifies with no issues but still will not publish, then the problem is likely something outside the model. Since you said you can publish with a stripped down model, I am assuming permissions are not the issue. I guess I would take a look at the Cognos logs immediately after you get the publishing error to see if there are any clues there.

[inu]

Hi
Thanks for your valuable response, First of all i would like to say that i did not install "transformer" except Cognos server and framework manager, that might be needed for creating  DMR model. If so then please tell me how can i install transformer software, where can i get this;
   
    Because when i publish other model except dimensional model, i get error in publishing the package. i m attaching the sreen shot,  Please find the attachment  and justify it bro.


Warm Regards
Inam

[Lynn]

Your attachment shows that you have errors which must be corrected in order to publish the package. I think the error message is pretty clear. Every level must have a key and a caption defined.

Suggest you review chapter 5 of the FM user guide, and the section on Dimensions in particular.

You do not need Transformer to build a DMR.

[inu]

Hi bro

Thanks!!!!!!!!!!!!!!!!!!!!

My half of the problem solved, i just checked  both "business key" and "member_caption" for the same signle quary item. I did right or not. please tell.
 
   Second thing is that i cant use "member_caption" for year and date query items as they dont contain string information. then in this situation how should i do, do i need to  add one more query item to these levels.

    Second problem is that, where should i check "unique level" ,. Is it necessary to check it, if so then how can i choose the unique level, or anyone of the levels can be unique level.

Red Carpet Regards
Inam

[Lynn]

   Second thing is that i cant use "member_caption" for year and date query items as they dont contain string information. then in this situation how should i do, do i need to  add one more query item to these levels.

You will need a string to use as the caption

    Second problem is that, where should i check "unique level" ,. Is it necessary to check it, if so then how can i choose the unique level, or anyone of the levels can be unique level.

This is covered in the Framework Manager user guide. Just search for "unique level" and you will find this and other explanation.

"If you want to indicate that the keys of the levels above the current level are not necessary to
identify the members in this level, select the item and select the Unique Level check box. This
indicates that key values belonging to the level should be considered unique regardless of context."

Hi bro

Thanks!!!!!!!!!!!!!!!!!!!!

You're welcome, but I'm not sure bro is commonly used when addressing a female ;)

[inu]

Hi lyn
sorry !!!!!!!!!!!!! for i did not identify you.

As per your reference, i went through user guide, where i explore the dimension topic at all. but didnot get the answer of my question. which is , if a query item is put into  a level, and data type of that query item is not set to "string". then how can i define it as "_memberCaption" which is mendatory to the level, what should i do in such a situation. e-g  "Year" and "Date" do not have string data type. please try to resolve my problem, dont refer me again to anywhere else.

With Regards
Inam

[Lynn]

dont refer me again to anywhere else.

:o


http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.cogsql.8.4.0.doc/cogsql_id1800cast.html

http://pic.dhe.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_fm.10.1.0.doc%2Fug_fm_id24380sql-99.html

http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos8-l/convert-date-data-type-to-string-data-type-3383788

http://www.temple.edu/ers/training_material/cognos_time_and_date_functions.pdf

[inu]

Hello sister Lyn

u know , the reference u have given me, that is quite out of topic say "Framework Manager Dimensional Modeling concept". I asked you only simple question, the answer might be in a single line, as far i think. And you taught about conversion concept of databse.
   
     I just asked you, that what should i do, in this case. and you gave me a big reference, that will take one day as a whole.
Why r you wasting your time in searching these links and mine as well. Why u bothering yourself, if u cant understand the question . Why reply.
     Five days left , i open and close this forum. waiting for a right and concise response. but you proved that you are a trustless woman. why i joined this forum, only for getting reference, even i can search in google the references you have given.

    The two things come into mind:
     1). Whether you dont have better knowledge of Dimensional medeling.
     2). or you got angry from my question.
   Please if you cant help one , never frustate them giving such kind of disgusting rubbish reference. I m totally depressed from your reference.     
          God Bless You.......

    Thanks and warm regards
   Inam

[Lynn]

Hello sister Lyn

u know , the reference u have given me, that is quite out of topic say "Framework Manager Dimensional Modeling concept". I asked you only simple question, the answer might be in a single line, as far i think. And you taught about conversion concept of databse.
   
     I just asked you, that what should i do, in this case. and you gave me a big reference, that will take one day as a whole.
Why r you wasting your time in searching these links and mine as well. Why u bothering yourself, if u cant understand the question . Why reply.
     Five days left , i open and close this forum. waiting for a right and concise response. but you proved that you are a trustless woman. why i joined this forum, only for getting reference, even i can search in google the references you have given.

    The two things come into mind:
     1). Whether you dont have better knowledge of Dimensional medeling.
     2). or you got angry from my question.
   Please if you cant help one , never frustate them giving such kind of disgusting rubbish reference. I m totally depressed from your reference.     
          God Bless You.......

    Thanks and warm regards
   Inam

The answer to your question is covered in every one of the links I provided. Since your data type is not a string and you need a string for the caption, then cast it to a string.

I will be certain not to bother you further with "disgusting rubbish"

:D

[blom0344]

Inam,

Please try to appreciate the feedback from some of the most respected and valued members of this forum. You certainly will not reap any benefit from reporting a post based on the fact that you do not appreciate that people try to help, in some cases by just pointing out where information is stored within documentation.

I suggest you apologize , read appropriate documentation and find some formal training

[bdbits]

Lynn is one of the most knowledgeable and helpful people here. Such harsh criticism was unwarranted and frankly offensive.

Everything you read here, any help or advice given, is volunteered; this is neither a classroom nor tech support. Frankly, your posts make it clear you do not understand the basics of the Cognos toolset. The links offered were an attempt to get you to start understanding what you are doing. That you cannot be bothered to read the documentation to correct these deficiencies and instead insist on being spoon-fed, on top of insulting those trying to help you, alienates those who might be willing to help you learn a thing or two.

As was suggested, hit the links and/or get some training.

[DustPanMan]

Inamulhaque,

After receiving a few complaints from very active, knowledgeable, and respectable members of the community, I have given you a "warning".  Please be aware that COGNOiSe is meant to be a place for members of the Cognos community to collaborate together.  Everyone on this site is donating their time.  When someone spends the time sending information with an effort to help you learn and grow in knowledge and is met with insults, it is very inappropriate.  Insulting members of this community is not only bad for your career (because if you do plan to learn Cognos, you will interact with people from this community frequently), but it will also get you banned if it happens again.  I have also sent you this message via email.

DustPanMan - Global Moderator

[inu]

Hi Lynn
I m really sorry, I m not a good minded person. What i perceived  about your knowledge , ablility for understanding the question.
was certaily wrong.
I realized in the morning, that you people are in the community for helping the others, whom you dont know instead.
I apologize for my bad comments to you.

    Please forgive me, other people in this community replied my bad comments and scolded me, except you.
  You say something.... if  you dont respond , then i will understand that, you didnot forgive me......I cant feel easy if you are angry to me. Please spit you angry....I bothered you a lot....Actually i was upset because my problem was not solved.....But no problem...It will ever be  solved. but i dont have right to hurt you image and calibre.You are dedicating your time to this site for helping others..... I should understand....

I dont know What post you are acquiring so far,..but you are a good human being.....Because you didnot respond to my disgusting comments.....And this shows that you have a wisdom and u know how to handle the situation.....


Please dont mind, and reply my comments.........

Thans and Regards
  Your obedients

[Lynn]

Inamulhaque,
Of course we all let our frustrations get the better of us at times. No worries on my account. I wish you all the best success and happiness. I am certain you will find that Cognoise is a wonderful community to be a part of.

Lynn

[MFGF]

Wow! What did I miss? :) I get dragged off to do some real work for a few days, and no sooner is my back turned than Lynn starts causing trouble ;)

Hee hee - she knows me well enough to laugh at that (I hope!) :) I'm very pleased to see you have come to an amicable agreement. The whole point of this community is for people to help each other and to share knowledge and ideas. We do have etiquette to observe, though. It can be seen as rude to demand answers or dictate what form answers should be given in, and I think this was a case in point. Bob makes a great point that all help offered on here is volunteered - nobody gets paid for helping out. Sometimes if we don't like the form answers are given in we just have to accept that while they may not be exactly what we hoped for, they are nonetheless an attempt to be kind and helpful. Being part of a community like this one can be a learning experience in many ways - not just technical.

There we have it. More ramblings from a deranged muppetoderator :)

MF.