Question Ashok S · Nov 30, 2016

Dear All,

From my web page, i am passing filter values to mdx query.

when mdx executes, i am getting Error #5001: Invalid member expression: empty name(2).

when i try the same in samples namespace (patient cube). I got the same error.

Below is my sample MDX from patients cube.

SELECT 
NON EMPTY %KPI("PluginDemo","HighScoreCount",,"%CONTEXT") 
ON 1 
FROM [PATIENTS] 
%FILTER %OR([HOMED].[H1].[ZIP].&[32000])

Result: 0   This works fine.

SELECT 
NON EMPTY %KPI("PluginDemo","HighScoreCount",,"%CONTEXT") 
ON 1 
FROM [PATIENTS] 
%FILTER %OR([HOMED].[H1].[ZIP].&[32006])

Result: 13   This works fine.

3
0 451
Question Ashok S · Nov 2, 2016

Hi All,

I need some help to create mdx for the following scenario.


My source table is like this format

FileName AuditDate FileType FileStatus AuditStatus
A 20161102 20 open 0
A 20161101 20 read 1
A 20161031 20 write 0
A 20161030 20 close 1
B 20161102 40 open 1
C 20161101 45 read 1
D 20161031 40 read 1
E 20161031 20 open 0
E 20161102 40 read 1
F 20161102 45 read 1

When the user selects any Date in my application, Till selected date results are displayed for all filename.

My current MDX is

5
0 536
Question Ashok S · Jul 12, 2016

Is there anything in deepsee where i can increase the cell width?

Column1

Column2

Column3

Sunday

100

200

300

Monday

100

200

300

Tueaday

200

300

400

By Default, based on the content, it calculates the cell width automatically.

From the above table i want to increase the width of weekdays cell particularly. Like below.

Column1

Column2

Column3

Sunday

100

200

300

Monday

100

200

300

Tueaday

200

300

400

I have written MDX Query in Kpi.

I tried with %Label with their arguments for cell style. It doesn't work for me.

Please give me some suggestions.

2
0 306