About AaseMargreteS_Strømsodd

AaseMargreteS_Strømsodd · ‎09-10-2012

First of all, thank you very much for your answer. We had already considered a similar solution to the one that you are suggesting. We thought that we could use an MDX-expression like this: IIf([Measures].[Antall_svarSUM]>30, [Measures].[SvarAVG], .) and create a new numerical expression based on it. The problem is that the user still will have the possibility to see the measure that we don't want the user to see (SvarAVG), it will still be a part of the cube.If we define this calculated measure in SAS OLAP Cube Studio, then afterwards, the user will see our new, calculated measure in addition to the measure SvarAVG.

AaseMargreteS_Strømsodd · ‎08-31-2012

My customer has created an OLAP Cube, where answers from their employees are categorized into gender, age, which job title they have etc. Their employees have given answers to more than 70 different questions. These results are then summarized on different organizational levels. Our customer want that only organizational sections, f.ex. a department, where more than 30 employees have answered, are shown. In other words, if a question is answered by only 10 people in a department, that question should not be shown in report if the user has drilled down to that level. I have created a measure that counts the number of answers for each questions, but there's not possible to create filters in Information Map Studio based on measures...? My customer's data source is an OLAP Cube. I know it is possible to make a filter on a report object in Web Report Studio on a measure from an OLAP cube, but the problem is that in WRS, a user can easily remove the filter again. Can anyone help my customer with this issue? Thank you so much in advance. Kind regards, Aase Margrete Strømsodd

AaseMargreteS_Strømsodd · ‎07-17-2012

Hi, You can promote Web Report Studio-reports from SAS Management Console. There, you have the possibility to export and make packages of your reports and information maps, and afterwards, you can easily import these packages again in SAS Management Console while connected to your production environment. Kind regards, Aase Margrete Stromsodd

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

Re: Filtering a measure on an OLAP Cube

Filtering a measure on an OLAP Cube

Re: How to deploy report without export...

Re: Filtering a measure on an OLAP Cube

Re: Filtering a measure on an OLAP Cube

Filtering a measure on an OLAP Cube

Re: How to deploy report without export...