Search results for query: *

This will calculate the time difference in seconds for two datetime columns: = DaysBetween(<DateColumn1> ,<DateColumn2>)*24*60*60 + (ToNumber(FormatDate(<DateColumn2> ,"h"))*24*60 + ToNumber(FormatDate(<DateColumn2> ,"m"))*60 + ToNumber(FormatDate(<DateColumn2> ,"s")) ) -...

Please help out making clear what it is you exactly want.

Yes. And make sure the column names are the same as in the old datasource. If they are not you can rename them in your model.

I think this is normal behaviour as you have TWO dimensions. So if you want to add a second dimension it will display all categories and not the product groups for the selected company as there is no hierarchy between them. If you want this you should rebuild your model/iqd's. Why doesn't...

I think it's impossible without editing the universe because you want to use a (databasefield + 7)... I don't think you'll be able to use this without adding an object in your universe.

It's 960 euro in the Netherlands I think (Powerplay Client)...

Sounds to me you should use the currency converter in stead of the Drill-through functionality...

The fact table exists in Access database while the dimension tables are in Oracle. Moreover, the dimension tables have a snow-flake structure. And the fact table contains reference key for only one of the dimension." If the Fact table contains only a reference key for only one of the...

laina, How dit you reformat the 1040101-date? The way it should be done is by <DATE>*1900000 and after this change your format.

Yes! That's one of the great advantages of Powerplay. Just keep in mind that the lowest level catagories in all dimensions are unique.

ReportNet is a reporting tool by Cognos, Brio is a Business Intelligence solution from Hyperion (nowadays) and Chrystal Reports is owned by Business Objects. I think a forumposting fails to completely explain de difference between 3 tools. Try Gartner.

Hi Eswar, Thing with Date-columns in AS400 DB2 is that these dates are often just Numeric values of 8 digits. Did you try to swap from D to N (or A because your error message is even refering to a string-value) in your @prompt?

Option "Refresh Structure" (under "view" in designermenu): Columns were added to tables Adds the columns to the corresponding tables in the universe. Columns were removed from tables Displays a warning message indicating the columns and associated joins you should delete. Tables were removed...

Sample: TRUNC(A_SALESCALL.CALLDATETIME) BETWEEN (@Prompt('Call Datum from','D','Contact\Contact datum',mono,)) AND (@Prompt('Call Datum untill','D','Contact\Contact datum',mono,))

Yes, correctly, except for the fact that I had NO Staff_name in my Pupils Table. I had a Staff_Nos in my pupils table (as I said in my prior post, I guess this is just a "slip of the keyboard" in your case...). This name equals the primary key in the staff table. Detect Joins worked ok.

No, I'm sorry, I meant that I've detected the joins in Business Objects. I never made any relations in Access. BO can detect joins on base of Keys and shared names. That's all. It will not effect your Access DB. In your example, where you've got 2 tables PUPILS and STAFF, it wouldn't be able...

I've completed a short test of creating joins in the Access-database. It seems that the functionality of "Detect Joins" (under "tools" in your menu) gets the trick done if key's are generated in Access and the columns which are linked to eachother in the facttable have the same name. Creating...

Creating Joins in your Universe will not change anything in your existing Access Database. I don't know if BO can see these 'implied' relationships with detect joins (I think it does), it looks at FK's and columnnames. But you should be able to create these joins yourself, it's not that hard is...

I don't undestand your question? You want to add/detect joins or something?

DB2 knows the concat-function in its SQL. So it would be something like: CONCAT(TABLE.FORNAME,TABLE.SURNAME)