Recent content by jobjoris

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.