What we want in the project is that the data in the database should be encrypted so that no one can access it directly. This data should be decrypted in BO when the user is running a report and shown to him. Can we do it in BO? Is there any way where I can call any external DLL / program to...
HI,
We have some sensitive data for the company. If this data is in encrypted format in database, can BO read and decrypt ot to display?
In general how can BO use encryption? Is there any way in BO to handle encryption, specially if we do not want to allow anyone to see the sensitive data...
Hi,
We need to setup two environments which share common components (universe and reports), one for support and the other development. We would like to make frequest releases to production from Support environment (fortnightly) and the frequency of releases from development will be less (once...
Hi,
In Cognos DS there are 2 types of connections for SQL Server; OLEDB and DBLIB. What is the difference between the two? What are each one's advantages and drawbacks?
Thanks and regards,
Gauri
Hi,
I tried the external rollup. The values are shown only when all the dimensions are at the lowest level. Can it be restricted only to one dimension? say only dimension 1 must be at the lowest level it should show 0, other dimensions could be at any level.
I was following the procedure given...
Hi,
Do you mean suppression using "Allocation" tab in the dimension? I tried that, but that is at the dimension level and also I guess the measures listed there come automatically depending on the table relations. I cannot add a measure there.
Thanks and best regards,
Gauri
Hi,
I need to hide a measure (or make its value NULL) if I drill down / up to a certain level of a dimension. e.g. I have a measure Credit Rating and I have dimension 'Customer' with levels All-Country-Customer. I want to display this measure only at the level 'Customer' and not at 'Country'...
Hi,
I am new to Cognos tools. Earlier I was using MS-OLAP for cube development. We have a function PeriodToDate() there which calculate running total from the begining up to that period. How can we calculate the same using Powerplay transformer? I tried using relative time categories, but...
Hi,
I am suppressing groups based on a condition, I want to show summary in the footer for these records only. If I use the normal summary function then I get the sum of all the records, including those that are suppressed. How do I do it?
Regards,
KA
Hi,
I want to print a report that will give me top customers contributing to X% of the total sales ans the relevant Items. X is an input parameter. So I use a running total field that calculated the running percentage. When the running percentage total exceeds the X value I want to suppress the...
Hi,
I want to show a group only if the records within it satisfy a condition. The condition is based on a Formula field of running total. How to do this? This condition is evaluated for each record. So if 4 out of 10 record in the group satisfy the condition, they are displayed with the group...
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.