About databobjr

databobjr · ‎02-21-2011

I just found other error information from the web studio log: 2011-02-21 17:52:09,483 [http-0.0.0.0-8180-7] ERROR [] com.sas.commands.olap.ShowDetailDataCommand - Drill through cannot be performed. No valid OLAP connection to get Show Detail results.Please contact your data administrator. java.lang.IllegalStateException: Drill through cannot be performed. No valid OLAP connection to get Show Detail results.Please contact your data administrator. What is a "valid OLAP connection"? Thanks, Bob.

databobjr · ‎02-09-2011

Hi, I try to user YTD and QTD function, from the OLAP Cube, to create calculate member. But when I put it on a report, it gave me this error: Formula error - The specified time level type is not found in the time dimension - in the "YTD" function My time dimension is: Year Quarter Month Day Any idea? Thanks, Bob Message was edited by: databobjr

databobjr · ‎02-07-2011

Thanks Angela! I did use the management console to update the metadata.(right mouse click and select update metadata). But it still did not work. I also deleted and registered the table again. But it still did not work. On thing I may need to point out, in development, we use a single server for all the SAS component. In production, we used multi servers. But I don't see this is a problem. Is there a log I can check for more details? Thanks again, Bob,

databobjr · ‎02-07-2011

I used an oracle view as my drill thought table. It worked fine in my development server. But when I moved it to the production server, it gave me the following error when I tried to drill to the details: " The immediate MDX execution failed select * from ... ERROR: SQL passthru expression contained these errors: ERROR: Incorrect length in SAS Metadata Repository for column xxx.... ERROR: The following columns were not found in the contributing tables: xxx.The immediate MDX execution failedThe server encountered an error accessing a source data table. " I used olap cube 4.2 M2 and Metadata server 9200 the database is oracle 11g Thanks, Bob Message was edited by: databobjr

databobjr · ‎01-31-2011

Hi, I use Oracle database. The date data type in the oracle table is date with include the time. such as 1/29/2011 12:34:23. When I tried to create a filter and prompt for it, SAS took it as a timestamp data type and it took in the date and time for the prompt. how do I eliminate the time part of the date string and use the data without the time. Also, there is no option for me to change the timestamp data type to date when I created the prompt. Thanks, Bob Message was edited by: databobjr

databobjr · ‎01-19-2011

Hi, I have a set of Libraries which were defined under the data library manager in management console. Now I need to move them to a different server, (same SAS version (9.2), just from development to production). How do I export theme and import them? In olap cube, there is an export package and an import package functions. I don't seem to see one under management console. Thanks, Bill. Message was edited by: databobjr

databobjr · ‎01-11-2011

Not all of data items cannot be defined in information map. For example, we have : date, new subscribers, existing subscribers, canceled subscribers. total subscribers, %new total subscribers = new + existing - canceled %new = new/total. report can be grouped by date,week, month, etc. In this report, the calculation cannot be done in information map. It need to be done on reports, Am I right? thanks, Bob.

databobjr · ‎01-10-2011

Hi, Is there a way to report Web Report Studio (4.2) Report Codes? In cube studio (4.2), one can report the codes of the cube and edit them and run it in enterprise guide to create a new cube. Can we do the same for Web Report? I created a few custom items in a Web Report (4.2), Is there a way to import them to a different report? Thanks, Bob.

databobjr · ‎01-10-2011

Hi, Can we have non data item filter or prompt in web report studio? For example, I need give users an option to group the report by day, week, month, etc.? I know that if it is using a cube as data source, they can just drill through the time dimension. But if I don't use a cube as data source, say just use an information map, can it still to be done? Thanks, Bob.

databobjr · ‎01-07-2011

Hi I want to have a from date and to date prompt for my report using olap cube as data source. When I try to create the date filter prompt, it dose not give me an option to create an individual date value prompt , i.e. let the user select a date from the calendar. Instead, it show a list of value base on the time dimension and the user need to select the dates from the long list. For example, if I want to see data from 11-15-2010 to 12-15-2010, I need to select all those dates from the list box. Is there a way to use just two date prompts for a cube report? I noticed that this kind of prompt is available for reports that do not use cube. Thanks, Bob.

databobjr · ‎01-06-2011

Thanks Angela. I created a cube and it worked with the mdx function. However, I need to produce a summary reports which the user can select a date from the filter, and the report shows something like: date select 12/20/2010 sale person, last 7 day Revenue, last 15 days revenue, last 30 days revenue If I did not include the time dimension on the reports, the MDX did not work. I used web report studio. Thanks, Bob.

databobjr · ‎01-04-2011

Thanks for pointing me to the menu. Yes. there is an option for "All possible value". It is a check box inside the include special values box in the prompt type and values window.(tab) Regards, Bob.

databobjr · ‎01-04-2011

Thanks Angela. But I am not using a cube, therefore, there is no time dimension (date). right? Regards, Bob.

databobjr · ‎01-04-2011

Hi I need generate an operational report which will look like the following: date ; Sales Person ; Today's Revenue ; sum of Last 7 Days Revenue. The source data table will provide data for date, sales person and today's revenue. Sum of last 7 days revenue need to be calculated for each sales person each day. Since this is a very simple report and I was trying not to use an OLAP cube. I wanted to use Information Map and create a data item to calculate the last 7 days' revenue. Since I am not using a cube, I can not use MDX function such as LastPreriods() (am I right on this?). Is there a function or work around to create a data item for this kind of calculation? Thanks, Bob. Message was edited by: databobjr Message was edited by: databobjr

databobjr · ‎01-04-2011

Thank you very much.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: ERROR: Incorrect length in SAS Metadata Repository

Sum(YTD(),[MEASURES].[])

Re: ERROR: Incorrect length in SAS Metadata Repository

ERROR: Incorrect length in SAS Metadata Repository

Oracle Date Data Type

Moving Data Library Definition to Other Server

Re: Export and Import Web Report Studio (4.2) Report Codes

Export and Import Web Report Studio (4.2) Report Codes

Non Data Item Filter or Prompt in Web Report

Date Filter Prompt For Cube Reports

Re: ERROR: Incorrect length in SAS Metadata Repository

Sum(YTD(),[MEASURES].[])

Re: ERROR: Incorrect length in SAS Metadata Repository

ERROR: Incorrect length in SAS Metadata Repository

Oracle Date Data Type

Moving Data Library Definition to Other Server

Re: Export and Import Web Report Studio (4.2) Report Codes

Export and Import Web Report Studio (4.2) Report Codes

Non Data Item Filter or Prompt in Web Report

Date Filter Prompt For Cube Reports

Re: Aggregate Functions in Information Map

Re: Dynamic Prompts

Re: Aggregate Functions in Information Map

Aggregate Functions in Information Map

Re: Add Tooltip to Report Column Name or Label