Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: vaass
  • Order by date
  1. vaass

    Restriction on Published Documents

    Blom Thanks for the efforts made.
  2. vaass

    Restriction on Published Documents

    Thanks Blom i too thought abt that..but the problem is i have 150-200 users, i cannot duplicate the user logins for all the users...is there any other way of doing it. Thanks again Vaass
  3. vaass

    Restriction on Published Documents

    Dear all My requirement is like, A user can view the published reports as well as create their own ad-hoc reports. Here i want to put a restriction on the user not to "Save As", "Export" or of any sort except viewing, only for published reports. Can somebody help me to achieve this...
  4. vaass

    Importing Excel into BO report

    Can you pls post a snapshot of the same with the drop down open
  5. vaass

    Bar and lines in chart not displaying to scale

    Hi Since you are using $ for all the units...it is not displaying...if you try with 3 measures with different units...eg...1 - $, 2 - Number, 3 - % then you can find the scale separately.. Try this and let me know
  6. vaass

    LPAD amount with -sign in Informatica

    This is working fine with IIF(AMOUNT>0,LPAD(to_char(AMOUNT),10,0),'-'||LPAD(Substr(to_char(AMOUNT),2,length(AMOUNT)),10,0))
  7. vaass

    OR Condition in Lookup Transformation

    Hi I don't understand ur question, is both the activation_date and de_activation date to be checked or...something else...pls explain further
  8. vaass

    Bar and lines in chart not displaying to scale

    Hi I have tried your problem...it depends on the unit you are using for the measures...actually it is showing the scale for all the measures. If the units are same then it will not be displayed separately..Just try with a different unit and check. Vaass
  9. vaass

    Problem during saving a document as Excel file

    Dear all I am facing a problem when i do a SAVE AS on a document as XLS in Version 6.5. The logo which i have in the document does not get exported in to the excel file...anybody have a solution for this. Thanks Vaass
  10. vaass

    How to remove duplicate rows everytime when a session is run?

    You can use a sorter transformation and check the distinct row checkbox in the property sheet of Sorter transformation. This checks the distinct row and populates in the target
  11. vaass

    Concate Function

    =Concatenation(Concatenation(<State> ,":") ,<Store name>) Example of concatenating State with Storename, in this case both the columns are of same data type...in case if you are concatenating different data type columns then you have convert them to an uniform format and then do the concatenation
  12. vaass

    Is there a good OLAP reporting tool

    There are lots of OLAP tool in the market, out of which Cognos & BusinessObjects are most popular. Comparing these two, i find BO is more userfriendly than Cognos, the BO product suite has an extensive features to satisfy almost any kind of reporting requirements. Also you have a lots of...
  13. vaass

    Help needed for history migration

    Hi all i am in process of migrating history into the existing data warehouse. Actually i have the current data warehouse with data from March'04. I have to populate data for 2 yrs back from March'04. Some of the kpi's are dependent on the previous months numbers. Actually our plan is to build...
  14. vaass

    Document on WebI SDK

    Does anybody have some document on WebI SDK, Please let me know. Thanks in advance Vaass
  15. vaass

    Urgent Help! Filter problem~

    You want to display the rows falling between 40% and 60%, if there is no record satisfying this condition then this will not return any rows. Hope this is what you want. I didnt understand what r u asking for. Lemme know
  16. vaass

    Urgent Help! Filter problem~

    Try this IF (<Part-Time Salary%> > 40% and <Part-Time Salary%> < 60%) then 1 else 0 For percentage calculation use NoFilter function Then rank the top 1 according to the flag variable
  17. vaass

    Urgent Help! Filter problem~

    A Question The fields are created at the report level or they belong to database
  18. vaass

    Linking Data Providers

    When you create different data providers in report, u have to ensure that there is a relationship key between them, once u create using this BO will automatically detects and creates a link using that field, if u miss any of the relationship field then you will not get proper results. Also to...
  19. vaass

    Unable to retrieve documents

    Hi Naga When u have upgraded to BO 5.1.6, did you point your BO to the same repository where your documents exists, check that, if not recorrect it and try again, this is not a bug in BO 5.1.6
  20. vaass

    Access Dates

    It all depends on the prompt where u have given, if u have given the date prompt in Report level the format you have to use is the default BO Date Format, or if u have given the prompt in Universe level then you have follow the database format.

Part and Inventory Search

Back
Top