Hi all,
I have to calculate a standard which is the lowest number roundup of the best 25% employees. example. 25% of the best is 7,5 which makes the standard 8.
Employee Numbers done
A 10
B 9
C 8
D 7
E...
Hi all,
Is it possible to create a drillthrough between reports when they use both a different datamart. If yes what are or should be the requierments for those datamarts?
Thx in advance!!!
Regards,
MissReportNet
Hi CognosChicago,
In our datamart we also have security tabels. I am also thinking to hire a dba to set authorisation en security at data level. Do you now or have more info about what a dba can do for us?
Thx!!
MissReportNet
Hi MF,
Thanks, i am sorry about your fingers :-). The questions i need has to be functional, some of what you have writen are functional like nr. 3,4,5,6,9,10 others are more technical questions. Can you come up with more functional issues?
Thx!!
Kind regards,
MissReportNet
Hi,
For authorisation and security issues the business has asked me to write some questions so they can discuss about the issue.
The security will be set top down and bottom up and line and based on capabilities, hierarcie, roles.
The only questions i realised is,
- who can see what
Can...
Hi Gary and Dave,
I thought also that it would be confusing when users are prompted to choose and it was my next case to find out.
Gary I would like to hear your testing results!
Cheers,
MissReportNet
Hi Dave,
After some testings I can confirm that pointing to multiple databases with different name is possible.
I have the following setup on my machine and works fine.
- One data source defined in Cognos Connection called 'Retailers'.
- There fore two connections under this data source one...
With ReportNet!!!! And I would also know, how many hours it will be cost to implement a test environment on a running environment.
Thanks in advance!!!!
CHeers,
MissReportNet
Hi,
Is it possible to achieve two database connections which are the same databases ( a test and a production) whith different names??
Cheers,
MissReportNet
Hi Jean,
Thx for your info. I take a look in the system.xml file but couldn't find a row with Schedule Managment entry. I have to hide the Schedule Managment entry. Can you please tell me more specified how to achief this.
Thanks in advance!!!
Cheers,
MissReportNet
Hi GJParker,
Insert a calculation and use
total([Gross Margin]for report)
call it total GrossMargin
Then insert a new calculation in expr. def.;
Gross Margin/Total GrossMargin, set data format as percentage.
Good luck!!
MissReportNet
Hi Nuffsaid,
I wanna thank you (* million times) for your information and effort. It works fine now and I am able to apply this on the reports. :-) :-) :-) :-)
Cheers,
MissReportNet
Hi Nuffsaid,
Thx for your suggestion and sorry for my late reply (holiday :-))
I am trying to do what you have written, but how do you copy the code to the clipboard? I can copy the report to clipboard if I have created a report but now i have only the xml code.
I am very curious??
Thanks...
Hi Nuffsaid,
Thx for your information.
Your first 2 alinea's i can manage. The drill throug link will be outside the main report body. That makes it diffucult for me. Can you tell me what to do from now on.
Thx in advance!!
MissReportNet
Hi,
You have to use an if then else statement.
Like:
IF([blabla] is 0) then (null)else ([bla2bla2])
Hope this will help you to get on the right track.
Cheers,
MissReportNet
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.