Does anyone know if a data dictionary exists for the 3 schemas that LBI installs  We are specifically interested in the Reporting Services schema, but Framework Services, and SmartNotes would also be helpful. Field names, sizes, descriptions, links to other tables, whatever exists out there. Thanks much, -Greg Moeller

When refresh data on the report for the first time, LBI will prompt the screen to ask user to enter ID and password to connect database. How to make it without asking user ID and password to connect to database I have enter the ID and password under the data settings screen in the report administration and also tried to create a datasource but nothing work I used SQL OLEDB connection. Any idea Thanks

I have been tasked with finding a way to automate the import of delivery devices for both Reporting Services and Smart Notifications. I can get a file created and it will work going through the 'wizard', but am wondering if there is a way that I can automate or script this This would cut down on errors, save time, save confusion.  ie someone changes their name, their email address changes too.  If we could figure out how to automate the import to both update and create new devices for chang...

hi, We try to setup LBI authentication against ADAM. We use advanced ldap/msad settings. Our ADAM contains groups and members for example G_LBIAdmins. After making the changes in the configurationAssistant, we restart IBM websphere.  The next step is to do an Authentication test in the InstallValidator. But we never pass this test. Always the same error : (security:3004) Login failed. The userid or password entered is not valid, or the specified user does not have access to this app...

Anyone set up one of these yet within Reporting Services

While trying to troubleshoot a problem with publishing reports in 9.0.4.1 LBI, I noticed that all the records in ers_reportdatasources have a 'square' after the value in reportdatasource. Looks like maybe control characters  I am using TOAD to view the data. Our database is Oracle 10g. Does anyone else have this issue

OK - trying to be very creative with this. Have reports that are not on-demand reports, but can't be scheduled at the same interval each period. Instead of allowing a group of users access to schedule a report to execute the thought was that we could come up with a java hack of some kind to give them the option to 'kick off' the report to run as a scheduled instance. I know that I can create a link on a dashboard (or on an icon next to a report link) with something like the following and it w...

Can you set up a Crystal Report with links (in our case to an Activity value) and open the report to that point in the report If you can, can you open a Crystal Report from a URL link in SmartNotes If yes to both, can you pass the Activity number as a parameter in this SmartNote URL link so the Crystal Report opens and jumps to that Activity

Hello Gurus, So we know very well that in order to create custom crystal report that use user level security, OleDB is an option. We also know that OleDb is really really sllllowwwww So, are there any other alternatives to this painful reality Can there be OleDb reports written with a language other then DME How about SQLOLEDB Thanks much,

Is there a maximum limit on the number of rows smart notes can burst For eg I am trying to write a smart notes that has more than 5500 rows of data and would like smart notes to burst each row. Has anybody experienced this issue What was your solution

We upgraded LBI to 9.0.4.1 a few weeks ago and just upgrade Crystal RAS to CR 2008 this morning.  One change we noticed is that CR 2008 now has tabs along the tops of the reports.  My guess is that any expanded groups will open in new tabs like they do in the Designer. This will be nice for those type of reports.  However, our problem is that there are a few reports that we have displayed directly in dashboard modules.  We hide the Group Tree and Toolbar so they just show the report data.  No...

Can you join the PRDISTRIB table to PRTIME I need to join the PRDISTRIB table to PRTIME so that I can get the hours from PRTIME. The reason I'm using PRDISTRIB is we have pr23 records therefore the distribution accounting unit is different in prdistrib then what is in prtime. I need to create a report that shows where the amount landed in GL and the associated hours (which do not write to gl). Thank you for your assistance in advance!

Does anyone know how to run an on demand Crystal report in reporting services without scheduling it and retain its history We just want to be able to run the report and not have to go through the set up of scheduling it.

Have a report link on a dashboard that provides users with only access to report instances - i.e., if no instance has been created it does not run on demand. This gets controlled with permissions properly. However, when users click this link - since they do not have data refresh permission - it gives them a 'somewhat' cryptic page stating: Message: This report doesn't have saved data, it can't be viewed, exported or printed without invoking a data...

hi all - i am wondering if anyone has used webrpt.exe to display files in LBI  i have done this before to display a print manager file, but i would now like to be able to display a work file (csv format) in LBI.  i am unable to use webrpt.exe, since the file path does not exist in the USERRPT table.  is there another way to display a file from the server (unix server) through a link in portal or - maybe there is a way to 'register' the work file in the USERRPT table thanks!

Does anyone know how to add parameters to the instance name or description automatically  We want our cost center managers to be able to easily tell which period the report is run  (older periods sometimes need to be rerun and it sometimes get confusing) instead of them having to go into each report. I know you can edit the instance name but we have over 50 reports and it would be a pain to have to edit 50 instance names.  Is there a way to display the parameters or append to the instance na...

I have been working on an Employee Position Report and created an array for all the departments to roll up into the union and report summaries. The array is capturing all the departments and printing them individually but it will not print them all simultaneously in the format we need for the Union Group Summary. The issue is not documented on the Lawson forums. Some Crystal internet forums documented the issue as a Crystal 2008 issue. I employed their print suggestions but none of them work wit...

Topic: Constructing Efficient Data Queries Using Lawson Add-Ins for Microsoft Office Host: Lawson Webinars Date and Time: Thursday, April 28, 2011 10:00 am, Central Daylight Time (Chicago, GMT-05:00) Event Number: 665 619 705 Event Password: This event does not require a password Registration ID: This event does not require an enrollment ID Topic: Work Smarter with Lawson Smart Office Host: Lawson Webinars Date and Time: Thursday, April 28, 2011 1:00 pm, Central Daylight ...

I'm trying to do a RW100 as a data source to Crystal Report for budget report. How do you define a RW report which includes all the account units Currently we have one RW report for one account unit in RW100.  So we have 50 RW100 reports for each account unit for its budget report.  Is it supposed to have all the account units in one RW when you want to use it as a data source for Cystal Report ( Each account units have the same account number for salaries, beneifts,....etc)  Otherwise,  I n...

We have several reports published in Reporting Services (9.0.4.1.156version) all of the reports are written in Crystal 2008 and have parameters.  When I request the report(in LBI) (on demand) it takes 30 seconds to return the parameter screen.  Does anyone have suggestions on how to speed this up  This is a new install so any fine tuning suggestions is much appreciated. Thanks

Hi I've installed LBI, DSSO & have intergrated with existing LSF 9 Portal. However, after logging in, I noticed that the Framework Services System Admin Tool is missing. This happens when I login as Framework services (like http://hostname:9080/efs) as well as in Portal. However, if I change the authentication to File Authentication, this issue does not appear I see complete menu. Has anyone come across this type of error earlier Any input is appreciated. Tks.

Created a new list with a couple filters and loaded to the module on the dashboard.  We are using Lawson security groups for access and bursting.  When user click on the link in the module they are converetde to my, or the list/report ownwers log in and security.  Anyone seen this before  We syncronized users but it did not fix the problem.  We are on 9.0.2.2.127... Help

Hi, All! Here's the issue:  The other day, I started seeing 2 Tools dashboards.  (I'm basically the guy that takes care of the technical stuff with LBI). I have a user here in IT that sees 3 Tools dashboards.  They are all identical (as far as I can tell). How do I differentiate between them to tell which is the 'real' tools dashboard and delete the other 2 Anyone ever had this happen to them Thanks in advance, -Greg

I am just curious to find out if anybody is using other BI tools that are non lawson supplied especially the analytics suite and whether you were sucessful in deploying thes BI enabled graphs, grids etc to LBI. I am particluarly interested in finding out more about microstrategy and silver light. Would love to hear about your experiences with these tools not for only reporting but for analytics. Thanks in advance.

I am able to burst smart note by process levels through email.  I created a list which mapping the pocess levels and users's email addresses. The question I have is if someone has multiple process levels,  he will receive multiple emails; each email is for each process level's data.  I wonder if there is a way to put all his process levels' data into one email only Any input will be much appreciated.  Thanks!