Recent content by yenfen

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, I tried the code but it only returns the active user class which is user. I was wondering if I can return all child userclasses under user? Thank you!!

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!!!

Same version. I disabled export to excel in the cube setting level. In a separate folder I created several reports using the cube. In that folder setting I enabled excel in the cube setting. Sorry I can't explain it very well. Does it make sense?

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...

Yes I did check the upfront server and it tested successful. (Server Name:8030) I packed the PPES server successfully, I just don't have any luck with IWR. Please help we are going to production really soon.

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 Thank you so much for the quick response. I'm doing the calculation after the cube is built not in the mdl. So it's not possible to drill through a calculation after the cube is built right? Unless I build a custom calculation within the model?

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!!

Thank you so much Skip. What can I do to allow user to type and match a certain item on the list? Is there another way?

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 :)