Current position:Home > essbase MDX

essbase MDX

Advertisement

Complex Essbase MDX Issue - Need Guidance

-0001-11-30

Hi, I have a complex Essbase issue in ASO version 11.1.2.2. Currently I have a MDX formula with a Measure member named '10th Percentile'. It calculates the 10th Percentile perfectly. So new requirement is to create a new Measures member and instead o

Essbase MDX Query Performance Problem

-0001-11-30

Hello, I'm doing an analysis in OBIEE to Essbase cubes, but I don't know why OBIEE generates two MDX queries against Essbase. The first one returns in a reasonable time ( 5 minutos ) but the second one never returns. With set [_Year] as '[Year].Gener

Essbase MDX Performance

-0001-11-30

Hello all, I am developing a report with obiee 10.1.3.4 sitting on top of Essbase and I am developing some reports which i am running into issues lately. The MDX generated by OBIEE is causing some performance issues especially in the reports where we

Essbase MDX question

-0001-11-30

Hi there I am at a client where I have to do comparative store analysis. Basically with MDX I need to do the following: When doing comparable store analysis on a daily level in my Time dimension a store must have traded a year ago on the same compara

Extract data from Essbase - MDX/Report Script

-0001-11-30

Hi, I was trying to extract data from an ASO cube using both MDX and Report Script approaches. I liked the MDX_ method since i could specify: - level zero members with values for the Revenue measure. SELECT {[Revenue]} on columns, NON EMPTY{[Accounts

Essbase MDX - string functions are not working!

2015-10-11

Hi all! this MDX code works fine (LEN function): With member Scenario.MS1 as 'Len([Account].currentmember.member_name)' select { Scenario.MS1} on columns from http://Planing.Budget this code raises error (UPPER or any string function): With member Sc

Is there any Update command in MDX query

-0001-11-30

My situation is follows:<BR><BR><BR> Jan-2005 Brands Products Sales <BR>Bill:20001-ABC 100<BR>Bill:20001-XYZ 20<BR> Customers<BR><BR>Is there any way where i can delete the member "Bill:20001-XYZ"

Essbase Filters and OBI

-0001-11-30

Somebody know if is possible to use essbase filters with OBI?... I need to import a cube in OBI, but with restriction, i.e. only a branch of a dimension. thank in advance. A.S.If you import the outline using one of the application administrator user

MDX: CrossJoin of generations same dimension

-0001-11-30

Hi all! How in Essbase MDX get CrossJoin generations of same dimension? to get result like this: Gen2     Gen3     Sales Qtr1     Jan     49 896 Qtr1     Feb     45 668 Qtr1     Mar     45 681 Qtr2     Apr     45 018 Qtr2     May     45 186 Qtr2     

MDX Info and Docs?

-0001-11-30

Hi, 2 points. 1) Can anyone recommend anything (reading material etc) to assist in getting to grips with writing Essbase MDX formula for ASO cubes? The user guide etc is practically useless unless you already understand the basics etc. 2) **When IS(Q

Performance problem with attribute dimensions - please help!

-0001-11-30

Hi everybody, I run OBIEE reports on top of EssBase 9.3 ASO cube. My cube has 8 regular dimensions and 10 attribute dimensions. I am running a query based on: - 3 dimensions (TIME, BATCH, MODEL), - 2 attributes of BATCH ( SHIFT, SHIFT_STATUS ) - and

OBIEE: non empty cross join function problem with some reports

-0001-11-30

Hi all, I am getting some problem ,when we are excuting some requests in OBIEE its taking long time , Actually our OBIEE is connected with Essbase when we are generating some reports its taking long time so i captured the Query in OBIEE and Iam excut

#UNAVAILABLE error in measures when using substr() in BO XI 3.1 SP3

-0001-11-30

Hi All, I'm using BO XI 3.1 SP3 with Essabse 11 for OLAP Connection. I got #UNAVAILABLE value for database delegated measures when using substr() on the dimension. The aggregation function have to be database delegated because the measure need to be

Unable to run reports due to too large set size

-0001-11-30

Hello guys I am creating a report with almost 12 columns. I know it has a lot of data. When I tried to add one more column which is day column, it gives me the following errors: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058]

How do I hide the MaxL query I wrote when I spool ther results?

-0001-11-30

Hi, I spoole the "Select" query I wrote to a cvs file, and I don't won't that the query will be presented but only the results. Does anyone know how can I do that automaticaly through MaxL Shell and not manually through Excel?Spool will always r

MDX and substitution Variable usage in Essbase 7.1.5 -- Problem

2015-10-11

<p>Hi,</p><p> </p><p>Iam trying to write a query like this and Iam unable to validatethis in MDX -</p><p> </p><p>SELECT<br><br>{ [USD]}<br>ON COLUMNS,<br>{&CurMon}<br>

OBIEE Evaluate - "Essbase error : Repeated dimension in MDX query"

-0001-11-30

Hi, I'm using OBIEE 11.1.1.6.2 BP1 on top of Essbase. I have a project dimension in Essbase with three levels - Total Project -> Project Class -> Project. I have created a new logical column in OBIEE to query two levels from project dimension, using

'Essbase Error: Repeated dimension [Accounts] in MDX query'

-0001-11-30

Dear Essbase Gurus, I have an error in a query passed to my Essbase cube from an OBI front end, but the errors states quite clearly that it is an essbase error: 'Essbase Error: Repeated dimension Accounts in MDX query' This is the query it generated:

OBIEE - ESSBASE   ERROR - 1200467 - Error executing formula for [MDX query]

-0001-11-30

I have an issue on essbase with a query with 50 member filters. The environment is OBIEE 11g over ESSBASE 11.1.2 with an ASO cube. The user for essbase are with database access filters. I have the following issue, OBIEE returns a query that filter 30

Essbase 11.1.2.1 - Converting BSO Member Formula to ASO MDX Formula

-0001-11-30

Hi all, I'm quite new at Essbase and I'm currently using Essbase 11.1.2.1. I have 2 cubes: one is a BSO cube and the other is an ASO cube. In the BSO cube, I have an account that has member formula: IF(@ISATTRIBUTE("US")) ("Sales"->