Hi,
i exported the table data using EXP.
Create the table with NO partitioning.
imported data using IMP with Ignore=Y
After import the table again has partitions.
-------
Is the only way is to rename the object to something, create the table without partition and use Select insert statement...
hi,
Did anyone experience any issues in importing the links from Upfront to Cognos 8?
I mean import all news items, powerplay reports and any URLs etc etc from upfront.
When i tried, I could not get the powrplay reports published from PP client in the cognos 8. Also the links in Cognos 8...
Nope. The month names' first three letters should be shown just as it does for other languages...
U mean there is a format preference settings for every language we can do?
thanks.
Sudhi
Hi,
I have applied cultural settings to date display and it is converting all western european languages perfetly. For example, 14-Dec-07 in English and 14-Dez-07 in German.
however it is not working for Czech language, it shows the month in roman numbers, example same date shown as 14-XII-07...
Hi,
Is there a way to list the file properties using the DIR command?
I have a folder with photos and in the explorer the folder displays the photo taken date. However for the same folder in DOS prompt, the date I am getting is last modified. Anyway I can get the details list out?
thanks.
Sudhi
Hi,
How to remove partition on a table? I want to retain the data and completely remove the partitionning.
drop partition option removes the data as well. the end result i want is a table without partitions.
regards,
Sudhi
hi,
Cubes are mirrored.
Does this mean if the cube on the primary server is DISABLED, then the request goes to secondary?
or is it just when primary server is not available (either service down or max connections reached), then only the request goes to secondary?
thanks.
regards,
Sudhi
to add more details...
If I access the cube from Upfront, i get cube (its accessed from primary PP server = SERVER2). When I disable the cube of SERVER2, it gives "The request failed because the cube or report is disabled."
Why when one server is down, the second is not taking the request?
hi,
Yes. All the services are running using local user belonging to administrator account.
All three servers have account called CognosService. These servers belong to my Corporate Domain group.
I am using CognosService user in all the servers, for all cognos services.
thanks.
Sudhi
Hi,
I am trying to configure multiple PPEs servers for load-balancing and mirroring. The servers are as below:
=======================
SERVER1 : contains IIS (webserver), PP gateway and Upfront gateway installed; Server is in DMZ (firewall between this and other servers)
---------------...
Hello,
The model has TWO IQDs. There are TWO measures and each from one IQD.
Case I:
The cube built from this is about 800MB.
Case II:
If I change the IQD2 (which has measure M2) so that it results in NO DATA, then the cube size is around 400MB.
Case III:
If I change the Cube properties...
Hello,
This is a bit tricky situation I am facing...
Currently I have cube called "Sales" and it contains sales from Europe. There are users from Europe, have their own reports based on the cube.
The change is, there will be American data coming in next. So the name "Sales" represents...
Hi,
How to create a cursor and process the data in loop; the cursor query is dynamic SQL. I mean the table names and couple of filtering parameters are passed at run time.
thanks for inputs.
regards,
Sudhi
Hi,
data entered via ASP.net website, which is configured to store in UTF8 format. The database is UTF8.
The data written via ASP.net is stored and displayed when queried just as entered. Users wont see any difference between wht they entered and view.
However when i see the data in Toad or...
Hi,
My database server set to GMT time. Users are from Asia, Europe and North america.
When a date column is inserted with current date during a transaction, it is currently inserted as system date (SYSDATE/TIMESTAMP).
What is the best approach for the users to see the date/time in their...
Hello!
wht would be the best approach to check password's validity, like say first character as an alpha, minimum one number and one special character, lenght 8 to 16 and so on.
The trouble is all over europe and asia. the character validation fails, the alpha's are different to englishmen to...
Hi,
I want to place a background image for a select list box. How to do that...
<select name="lstGroup" size="6" style="width=280px">
....
</select>
When I add background-image: url('images/background.jpg') in the style, its not showing the image as background.
thanks in advance...
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.