Search results for query: *

Hi All, I recently implemented hierarchy userclasses security into transformer model. There are about 69 userclasses for one cube. After I published the cube to upfront, PPES server keeps hanging. Is there a limit of how many userclass I can implement in the model? Please help! Thank you in...

Hi All, Is it possible to export userclass created in the catalog to a file? Currently, we have 800 userclasses in the catalog. It's difficult to replicate the same useclasses in Access Manager. Is there an easier way to do this? Thanks in advance!!!

Hi, I'm trying to give certain user the ability to export to excel in Upfront PowerPlay Reports. The cube property itself doesn't have the capability to export to excel. I tried to get around it by creating folder contain reports and change the cube setting in the folder property to enable...

When I tried to import a text file (approx. 500mb) I get the following error: "Could not find the selected row delimiter within the first 8kb of data." What does it mean? and how would I get around it? Thank you!

Hi All, I'm limiting user from exporting more than 80 PDF pages from Upfront (running IWR reports). I used the catalog governor and set the data retrieval limits to 1500. (It PDFs 80 pages) It worked fine in the Impromptu client version but once I published the IWR report to Upfront, if the...

Hi All, I am using Deployment Manager (version 7.3) to pack IWR on the server. I don't have many IWR reports, however everytime I tried to pack it, it will always timeout. The following are the errors I got from the trace log. ERROR [00000fd8][common] Connection...

Hi All, I followed the step by step instrution writting in the Administrator Guide for IWR Auditing. The database is created in SQL Server, data sources are added to IWR server and IWR report. The audit logs are created in the appropiate path. I tried using the IWR audit file processor to...

Hi All, Is it possible to drill through a calculated column in powerplay 6.6 ? For example: Col A = 30 Col B = 10 Col A - Col B = 20 When I tried drill through the calculated column, the impromptu report would only return 10 (Value of Col B). What am I doing wrong? Thank you!!

Hi, I'm pretty new with this so please bear with me. I have a spreadsheet that contains multiple look up spreadsheet. I used data validation to create the primary spreadsheet by using a list. I understand by using data validation it created a drop down list (combo box?). I want the users to be...

Hi, How do I change a personal catalog to a share catalog. Do I need to do redo the catalog or just add user classes? Thanks so much :)

Hi All, I'm trying to convert impromptu catalog from 6.6 to version 7.1. I was able to upgrade the version from 6.6 to 7.1 and verify it. But when I tried to add a table from the database (SQL Server 2000) I was not able to do so. The Qualification Tab is grey out also. Please help. Thank you...

Hi I'm trying to add 10 days (2 weeks) to the end of a fiscal year in Transformer (I'm using a lunar calendar - 52 Weeks). Example: the fiscal year 2003 ended in 9/20/03 but I want it to end in 10/4/03 (FY03 Quarter 4). When I generated the cube, it wants to put 10/4/03 as the next fiscal year...

Hi All, I'm having a problem with Time Frame in Transformer when generating the cube. The problem occured when I tried to add an additional pay period in the current Fiscal Year 03. For example, the current period should have ended in September 20, 2003, I wanted to to extended for another 2...

Hi All, I couldn't figure out how to solve the TR1319 error problem? What exactly does it mean? Thank you!!!!

I'm trying to load a date in SQL Loader Here is what I have in the file 1/22/1999 12:00AM How do you do it? I'm using date "mm/dd/yyyy HH24:MM" and it kept failing? Please help!! Thank you!!!

Is there any possible way to do alternating row conditional Formating in Impromptu? Thank you!!

Hi All, This is my current powerplay report Occupation Gender Male Female Total Age < 30 25% 75% 100% 31- 40 30% 70% 100% 41 -50 20% 80% 100% This is the end result I want Occupation Gender Male Female Total Age < 30 25% 75% 100 31- 40 30% 70% 100 41 -50 20% 80% 100...

Hi, I want to count NULLs in Access Query, I kept getting zero count. can anyone help? The following is the query I'm currently working on: Select DISTINCT (Select count(MISSION) from tblSATISFACTION where MISSION IS NULL) as NORESPONSE, from tblSATISFACTION; Thank you!!!!!

Hi, I'm not sure whether to do this in Impromptu or Powerplay? I created a report like this Job Security 147 48 38 Satisfied 17 21 12 Neutral 13 8 3 Dissatisfied 117 19 23 Fairness 150 60 16 Satisfied 68 33 1 Neutral 70 8 4 Dissatisfied 12 19 11 However, I want to...