As title, I need a date interval(ex. 20050801~20050831) report entering by user.In a word, while report was opening(in improptu 6),users can enter the date interval condition they like.
I see the help, just see the one condition, how to design this prompt manager items!!!
Thsnks a lot!!
hi, dear all:
I try to use the "incremental cube" attribute, but the task is not work (the errow message show the TR0214).
This made me not "updent" my cube, as a result, the cube size is big.
thanks alot!!!
the log file is shown as:
http://home.so-net.net.tw/ggimmi/e11.txt
Message TR0214
The...
The case I’ve met now is following:
My boss ask me to split the cube we use now!
Because the cube update is too slowly(the cube size now is about 5~600MB)
How to split this cubes right now and do not interrupt its routine job.
Can transformer6.6 & windos2K to adjust this request?
Thanks for help!!
thanks for your helps!
I ask to the system administrator for your opnion, and he adjust the folder permission I ever use. Now, I'm trying and hope success!!
Thanks again!!
hi, dear all, thanks for help:
My autobatch is following:
trnsfrmr -n -s -z X:\*.pyi
(since I'm keeper not original creator, what the "-z" means? I didn't find on doc or anywhere! )
and this is my log file:
http://home.so-net.net.tw/ggimmi/e1.txt
When my cubes(*.batch) is updated, my cube size became smaller than the before one(becaue I once try to create it in transformer manually).
Why do I use the transformer to create cube, the cube is updated normally and correctly(I can see the correct value on *.ppr!!), but, when my...
dear all:
Thanks for helping.
while I transform the cube, the process was interruped by error message (TR3311), and then I check the document about (error: TR3311) that is shown following:
------------------------
An error occurred during data retrieval from the database. Refer to Details for...
I created a datefield table in database to solve the problem 1. above at first.(Because I want to trial the other in advance)
when I add that calculated field as your opinion above:
I got the 'cross product' error following :
---------
**** ERROR ****
This report will result in a 'cross...
hi,DoubleD:
I'm back unfortunately!! ^_^|||
1.I try to create the "datefield" hotfile you suggested, the way I try to is create the each month in "Excel" then I save it as *.csv, but I do not see it(that hotfiles)in Impromptu's catalog->Tables->hotfiles->browse when I want to add it to the...
Thanks for reading!!
1.Where do I add this "Sum(If (DateField between (E_arrival_work_date) and (E_departure_date)) Then (1) Else (0))"
2. I have aready built a row data's iqd (which is compose of start-work & End-work field and etc..). where do I set the result-table(means the...
Thanks Mr.DoubleD!!
I try to design the *.iqd you suggested, the result is not good because of "emoployee's work-time counting" !!
----------------------------------------
I have tried to use function "count",but the rusult-number just caculated only "a day" that employee's...
Thanks a lot for helping!!
Now, I'm trying to design such *.iqd and test it, but something is confused me--> the "employee count" change very sooner, is any way to calculate it in dynamic updating??
Hi,
thanks a lot first for helping!
The situation is I want to design a dimention(measure) about the employees-quantity at our company(department)in one special period.I don't know how to design that!!
----
My data record
-----------
E_id, E_name,E_dept, E_arrival_work_date...
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.