You may want to make sure that your Time dmension is set to a type of "Time" and not "Standard". This will ensure that all of the time functions are available to you. If this is set to standard, they will not be. ... View more

The source for the drill-through is Oracle, correct? http://support.sas.com/kb/12/215.html "Most connections to the data are performed using the OLAP Server's process ID. The exception to this is a SAS/ACCESS library against a third-party RDBMS when the USER option has been specified." My guess with the error below is that the OLAP Server process id is trying to connect to Oracle and doesn't have access. ~ Angela ... View more

> 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. > can you make or use the prompt as a range between &date 0:0:0 and &date 24:0:0 ... View more

Also note that I have posted two different options on how to migrate OLAP cubes: http://sas-bi.blogspot.com/2010/10/moving-olap-cubes-part-1-its-all.html http://sas-bi.blogspot.com/2010/10/moving-olap-cubes-part-2-management-has.html ~ Angela ... View more

Actually, you can define these measures in the Information Map. Using the expression editor, you will need to include code that works in SQL. For the example total subscribers = new + existing - canceled, you will need to do something like the following: CASE WHEN subscriber = new THEN 1 ELSE WHEN subscriber = existing THEN 1 ELSE WHEN subscriber = canceled THEN -1 END Then on the data item properities 'Classifications, Aggregations, Formats' tab - verify that this is defined as a measure with the only aggregate function as SUM. ~ Angela http://sas-bi.blogspot.com ... View more

I seem to remember a sample for this somewhere but I havent been able to quickly find it. Included is one that might work - creating a custom table of contents where the users could choose whether to look at day/wk/month - and it link to the section of the report with those columns in use. http://support.sas.com/kb/37/459.html ~ Angela http://sas-bi.blogspot.com ... View more

I was going to suggest creating two filters in Information Map (such as Start Time and End Time) however when selecting both of these within Web Report Studio a pop-up arises stating that only one filter per dimension can be used. The other option is a SAS Stored Process where two prompts can be created. Note that the Stored Process code will need to include the proper MDX statements to select the range of members between the start time and end time prompt selections. Similar to the construct: {([Time].[Month].[1] : [Time].[Month].[2] )} ~ Angela http://sas-bi.blogspot.com ... View more

The Time Dimension needs to be included in the MDX query for the calculated measure to be generated. In Web Report Studio, the query is generated automatically by what is used/included in the report. Therefore what you are seeing is expected. If you would prefer to not include the dimension in the result, an alternative is to utilize a SAS Stored Process within your information map that queries the OLAP cube and generates the data result for Web Report Studio to then display. Bypassing the Information Map query is discussed in a webinar I presented last month. http://support.sas.com/documentation/onlinedoc/guide/webreportstudioperformancewebinar.htm ~ Angela http://sas-bi.blogspot.com ... View more

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

Thank you very much. ... View more

Thank you very much Angela and sorry for the late reply. I also took a detour for something else. I tested it last Friday and it work. Thanks again. For those are newbies like me, if you are not sure how to get the libname, etc., you can get LIBNAME Statement from the management console. Here are the steps: After logging on to management console: 1. Expanded the Data Library Manager folder 2. Expanded the Libraries folder 3. Highlight the library which you want to get information from. 4. Right mouse click and select Display LIBNAME Statement. 5. Copy the LIBNAME statement. Bob. ... View more