Hi, I would like to get a report like this
Item Cost
AAA 10
BBB 25
CCC 100
which displays only the latest cost information for an item.
The fact table has following values
Item Date Cost
AAA 08/02/05 20
AAA 08/04/05 10
BBB 08/01/05 50
BBB 08/02/05 25...
Hi, how to do exception reporting. If i have duplicate records in my table, i would like to show uniquely that these are duplicates.
Order_Id,Order_Date,Order_value , Combination of this is duplicated in the table by whatsoever reason. How can i get the report to do exception saying that these...
Hi,
I have a nested prompt , say Year==>Quarter. I pick up Year=2004 and being nested my Quarter shows values pertaining to that year. This prompt is optional. Since I want all the Quarter values belonging to Year=2004 i don't select any at this level. The SQL generated doesn't contain any...
Hi, I have services configured to Save To File. Services are running successfully but i don't see any file getting saved in the said location. Whats missing in my setup ? Any ideas..
Thanks
Hi,
I need to run services based on information thats loaded in the warehouse. We have number of customers whose data comes and gets loaded at different time. Every customer has a service associated with it. As soon as "customerA" load is complete i would like to kick off the "serviceA". For...
Hi, How to setup an enviornment where we have WebI on unix and Publisher on Windows(i think we cannot have publisher on Unix). I am using BO Enterprise 6.1a suite. Any suggesstions on setting up the environment.
Thanks
nlim, this could be a good candidate for your WISH LIST. I see a great advantage with this feature(triggering datamart from a report to utilise the objects created by datamart in the report) in the tool.
Thanks
entaroadun and nlim, you are correct. i have to run my datamart every time when i have to run my report. I agree as you said that it defeats the basic urpose of datamart. i am using this datamart as one of those multipass SQL and using the metrics generated in the report. I am looking for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.