Skip to content
July 9, 2014 / Rodrigo Chiolas

OBIEE – Creating dependent presentation variable

Problem

Sometimes we need a presentation variable that depends on other variable, and probably must be hidden from end-users.

Solution

First we create a dashboard prompt with a presentation variable, that should display the available options to end-users.

Next  another dashboard prompt with a second variable, that depends on the first. Use SQL Result, like this example:

SELECT case when '@{p1}{P Type}'='P Type' then '"Products"."Product Type"' else '"Offices"."Department"' end FROM "Test"

or

SELECT distinct "Calendar"."Month Num"  FROM "Test" where  "Calendar"."Month " = '@{m1}'

Now hide the second dashboard prompt. We can:

1. Use a section with condition set to false

2. Use Custom CSS Style: display:none

3. Dashboard properties variables

– Edit the dashboard

– Go to “Dashboard Properties…”

– In ‘Filters and Variables’ add the second dashboard prompt

 

Finally, when we need to use the second variable, we should add the first variable as a hidden column on the analysis, so the visible dashboard prompt can refresh the second variable.

 

Ref: http://obieeil.blogspot.pt/2013/08/obiee-creating-dependent-implicitly.html

 

July 9, 2014 / Rodrigo Chiolas

Reporting Servives: Memory gates checking failed because the free memory

Problem

“Memory gates checking failed because the free memory (X bytes) is less than Y% of total memory.” – this is the typical error message.

Solution

Just edit the webconfig and set minFreeMemoryPercentageToActivateService to 0 on serviceHostingEnvironment :

<configuration>
 <system.serviceModel>
 ...
  <serviceHostingEnvironment ... minFreeMemoryPercentageToActivateService="0"/>
 </system.serviceModel>
</configuration>

 

July 9, 2014 / Rodrigo Chiolas

Dashboard Designer 2013 – Cannot load database for new SSAS datasource

Problem

At dashboard designer,  when trying to create a SSAS datasource, the step to select a database, only shows “Loading..”, and you cant select a database.

Solution

On SQL Server you need to install SQL Server xxxx ADOMD.NET, where xxxx is the version of sql server, e.g., 2008, 2012.

You can try now, but it is probably that you still see an error.

For some reason, version installed and version configured it is usually different, so you probably need to edit the config file.

Go to the path (or equivalent):

C:\Program Files\Microsoft Office Servers\15.0\WebServices\PpsMonitoringServer

In the Web.config file:

<runtime>

<assemblyBinding xmlns=”urn:schemas-microsoft-com:asm.v1″>

<dependentAssembly>

<assemblyIdentity name=”Microsoft.AnalysisServices.AdomdClient” publicKeyToken=”89845dcd8080cc91″ culture=”neutral” />

<bindingRedirect oldVersion=”9.0.0.0″ newVersion=”10.0.0.0″ />

</dependentAssembly>

</assemblyBinding>

</runtime>

This code is just changed to:

<runtime>

<assemblyBinding xmlns=”urn:schemas-microsoft-com:asm.v1″>

<dependentAssembly>

<assemblyIdentity name=”Microsoft.AnalysisServices.AdomdClient” publicKeyToken=”89845dcd8080cc91″ culture=”neutral” />

<bindingRedirect oldVersion=”10.0.0.0″ newVersion=”11.0.0.0″ />

</dependentAssembly>

</assemblyBinding>

</runtime>

An it should solve your problem.

Ref: http://www.c-sharpcorner.com/UploadFile/a9d961/create-an-analysis-service-data-source-connection-using-shar/

 

July 9, 2014 / Rodrigo Chiolas

SSRS: Report won’t run when selecting too many parameter values

Problem

When trying to select too many parameter values on a report, it won’t execute. But if we select fewer it runs.

Solution

We just need to add, to the web.config file from SSRS, this entry:

<appSettings>
    ...
    <add key="aspnet:MaxHttpCollectionKeys" value="9999" />
    ...
</appSettings>

And it should solve the problem.

July 9, 2014 / Rodrigo Chiolas

Oracle error – CursorFetchMapTerminationRTV20007

Some days ago, when executing an OWB package, i’ve encountered the annoying CursorFetchMap error, more specific the CursorFetchMapTerminationRTV20007.

This problem its not exclusive from OWB, it can appear on views, procedures, etc. Usually it’s followed by an ORA-0xxxx error code, and  an error message, e.g. “ORA-01722: invalid number”.

There’s not an exact formula to resolve this problem, but we can follow some tips to find the problem.

The approach depends on the error, the 2 most commons are:

  • Invalid number
  • Invalid date ( the error can vary, for example, invalid month or invalid year)

Invalid number

Occurs when the database its expecting a specific decimal and/or thousand separator, and it gets another.

  • Check the NLS_NUMERIC_CHARACTERS
  • When converting from a varchar2 to a numeric, add NLS_NUMERIC_CHARACTERS to the to_number() function, e.g.:
    to_number( value ,  '999G999G999D999999' ,   'nls_numeric_characters='',.''')

Invalid date

Occurs when the database it’s expecting a specific date format and it gets a different one.

  • Check the NLS_DATE_FORMAT
  • When converting from a varchar2 to a datetime, check the NLS_DATE_FORMAT of the to_date() function, e.g.:
    to_date(ds.process_date ,  'yyyymmdd' )

Hope it helps,

July 8, 2014 / José Cardoso

SharePoint 2010: Solution Package Deployment stuck in Deploying status

Symptoms:

Usually we are able to successfully deploy/update a solution package (that is, a solution with a group of visual web parts) inside our SharePoint 2010 farm. We deployed/updated the solution through the command “Update-SPSolution –Identity <SolutionName>.wsp –LiteralPath <Solution Location>\<SolutionName>.wsp –GACDeployment –force” in the SharePoint 2010 Management Shell. When we tried to updated the solution, we verified that it solution wasn’t updated. We noticed that the deployment status in the SharePoint 2010 Central Administration the Status was always “deploying”.

Problem:

 The problem can be related with one of the points bellow

  • Microsoft SharePoint Foundation Workflow Timer Service is not running
  • SharePoint Timer service is not running

Solution:

To check the execution of the service of the point 1:

  • Open the SharePoint Central Administration Portal
  • Go to Manage services on server, under System Settings
  • Verify if the service “Microsoft SharePoint Foundation Workflow Timer Service” is running. If not, start it

services on server

 

To check the execution of the service of the point 2:

  • Open the Windows Services window to check the services that are running in the server
  • Find the “SharePoint 2010 Timer” service and verify if it is running

services

  •  If the service is not running, open the command line prompt
    – Type the command “net start sptimerv4” to start the service and press Enter
    – If you receive “The service did not start due to a logon failure.”, edit the “Log On” account to ensure that the service identity account is configured correctly and start the service

After making sure all the services are running, deploy again the solution.

Reference:

http://technet.microsoft.com/en-us/library/ee924649(v=office.14).aspx

March 18, 2014 / Rodrigo Chiolas

OBIEE Dashboard prompt: at least one mandatory

When one of the prompts must be filled but you don’t want to put both as mandatory

Link to the article: http://www.rittmanmead.com/2014/03/obiee-dashboard-prompt-at-least-one-mandatory/

%d bloggers like this: