Formula Error - Cannot find dimension member

When I run a MDX query for a specific date, where I donot have any data in the fact table, I get the error - "Formula Error - Cannot find dimension member "--" - in a name binding function.
Query 1:
select {[Measures].[BlockOrders]} ON COLUMNS
from USAGEDETAILS
WHERE [Trdate].[All Trdate].[2002].[July].[30]
This works fine, but if I run the following query, I get the above error message, because there is no data for July 1st, in the fact table.

select {[Measures].[BlockOrders]} ON COLUMNS
from USAGEDETAILS
WHERE [Trdate].[All Trdate].[2002].[July].[1]

Can some one help me?
Thanks,
Sophia.We have two tables Loans (Parent) & LoanIndicators (Child).

LoanIndicators stores the Loan status (ex Outstanding Amount) date wise. This table is updated with a new record only when the Outstanding Amount Changes , until that time the last record holds the status.

Ex :
Loan Table
Id LoanId LoanAmount
1 L1 1000
2 L2 2000

LoanIndicator Table

Id LoanId IndicatorDate Outstanding Amount
1 L1 1/1/2005 100
2 L1 1/13/2005 90

So in the above case if i want to know the Outstanding amount on 1/10/2005 of L1 i.e the record dated 1/1/2005 gives me the outstanding amount of 100.

To Create a Cube on this I create a View linking Loan & LoanIndicators i.e the view holds all the Parent + Child Records of each of the Loans.
Also the cube has a dimension on IndicatorDate.

Now in the Cube the Total AMount of Loan disbursed is 4000 but it shouold be 3000.
It is 4000 because it is summing L1 twice as the view has two records for L1.
1) How do we prevent this summing of L1 twice ?

2) If I want to know the Outstanding Amount on 1/10/2005 for L1 , how do i get it (It should be 100 as the position only changes on 1/13/2005).

TIA

Shuchi Agarwalsql

Formatting Issue

Hi

I am using Reporting Services 2005. I have deployed my reports on mutiple servers. It works fine. But on a specific server, when I deployed my reports, its formatting disturbed for a specific font. Wherever I have used Font:

Name: "Arial Narrow"

Size: 8pt

Style: Normal

Weight: Bold

Decoration: None

its size changed and disturbed the whole formatting. It is something related to server settings, but I dont know where to change the formatting to solve the issue. I have tried to change the system display resolution, but it didn't worked. I cant re install server as it is client's machine. It has "Microsoft Windows 2003 Server" installed on it. Please help me to solve the problem.

Looking for a quick response.

I have tried to install Arial Narrow Font on the server. It is installed successfully but the problem is still there. Can anyone help me out to solve the problem.

Urgent

|||

try to check ur issue in this file

ReportingServices.css its available in styles folder under reports folder in IIS or check out styles folder in reportserver folder in IIS

|||

Did you find a solution to this problem?

I'm getting the exact same problem, in the exact same scenario: Deploying to a new Windows 2003 server (of which I don't have complete control) with my Arial Narrow 8pt fonts (normal and bold) being rendered incorrectly. One point: initially the server did not have Arial Narrow on it. I added the font and this improved the situation (arial narrow is being used) but it isn't being rendered like arial narrow should be. Lot's of spacing and padding around each letter, which themselves not looking like arial narrow. If I cut and paste the PDF content into another document (word or outlook) the text is pasted as arial narrow perfectly (not looking anything like the text appeared in the problematic PDF).

|||I am having similiar issues. I have complete access to the pc's displaying the reports and the servers running the reports. I am looking to use a font such as Trade Gothic (our company font) and I am trying to get it to render into the PDF. I have installed the font on all machines and servers involved in the report generation and no success to date. I can get it to show up as HTML output, because that is reliant on the machine to support the font, however when I export to a PDF it falls to the default Sans-Seriff font. Any ideas?|||You have to reboot the server after installing a new font.
|||After initially trying to just install the missing font (which did not work), installing the font and then rebooting the server did the trick! Thanks.
sql

Formatting Issue

Hi

I am using Reporting Services 2005. I have deployed my reports on mutiple servers. It works fine. But on a specific server, when I deployed my reports, its formatting disturbed for a specific font. Wherever I have used Font:

Name: "Arial Narrow"

Size: 8pt

Style: Normal

Weight: Bold

Decoration: None

its size changed and disturbed the whole formatting. It is something related to server settings, but I dont know where to change the formatting to solve the issue. I have tried to change the system display resolution, but it didn't worked. I cant re install server as it is client's machine. It has "Microsoft Windows 2003 Server" installed on it. Please help me to solve the problem.

Looking for a quick response.

I have tried to install Arial Narrow Font on the server. It is installed successfully but the problem is still there. Can anyone help me out to solve the problem.

Urgent

|||

try to check ur issue in this file

ReportingServices.css its available in styles folder under reports folder in IIS or check out styles folder in reportserver folder in IIS

|||

Did you find a solution to this problem?

I'm getting the exact same problem, in the exact same scenario: Deploying to a new Windows 2003 server (of which I don't have complete control) with my Arial Narrow 8pt fonts (normal and bold) being rendered incorrectly. One point: initially the server did not have Arial Narrow on it. I added the font and this improved the situation (arial narrow is being used) but it isn't being rendered like arial narrow should be. Lot's of spacing and padding around each letter, which themselves not looking like arial narrow. If I cut and paste the PDF content into another document (word or outlook) the text is pasted as arial narrow perfectly (not looking anything like the text appeared in the problematic PDF).

|||I am having similiar issues. I have complete access to the pc's displaying the reports and the servers running the reports. I am looking to use a font such as Trade Gothic (our company font) and I am trying to get it to render into the PDF. I have installed the font on all machines and servers involved in the report generation and no success to date. I can get it to show up as HTML output, because that is reliant on the machine to support the font, however when I export to a PDF it falls to the default Sans-Seriff font. Any ideas?|||You have to reboot the server after installing a new font.
|||After initially trying to just install the missing font (which did not work), installing the font and then rebooting the server did the trick! Thanks.

Formatting Issue

Hi

I am using Reporting Services 2005. I have deployed my reports on mutiple servers. It works fine. But on a specific server, when I deployed my reports, its formatting disturbed for a specific font. Wherever I have used Font:

Name: "Arial Narrow"

Size: 8pt

Style: Normal

Weight: Bold

Decoration: None

its size changed and disturbed the whole formatting. It is something related to server settings, but I dont know where to change the formatting to solve the issue. I have tried to change the system display resolution, but it didn't worked. I cant re install server as it is client's machine. It has "Microsoft Windows 2003 Server" installed on it. Please help me to solve the problem.

Looking for a quick response.

I have tried to install Arial Narrow Font on the server. It is installed successfully but the problem is still there. Can anyone help me out to solve the problem.

Urgent

|||

try to check ur issue in this file

ReportingServices.css its available in styles folder under reports folder in IIS or check out styles folder in reportserver folder in IIS

|||

Did you find a solution to this problem?

I'm getting the exact same problem, in the exact same scenario: Deploying to a new Windows 2003 server (of which I don't have complete control) with my Arial Narrow 8pt fonts (normal and bold) being rendered incorrectly. One point: initially the server did not have Arial Narrow on it. I added the font and this improved the situation (arial narrow is being used) but it isn't being rendered like arial narrow should be. Lot's of spacing and padding around each letter, which themselves not looking like arial narrow. If I cut and paste the PDF content into another document (word or outlook) the text is pasted as arial narrow perfectly (not looking anything like the text appeared in the problematic PDF).

|||I am having similiar issues. I have complete access to the pc's displaying the reports and the servers running the reports. I am looking to use a font such as Trade Gothic (our company font) and I am trying to get it to render into the PDF. I have installed the font on all machines and servers involved in the report generation and no success to date. I can get it to show up as HTML output, because that is reliant on the machine to support the font, however when I export to a PDF it falls to the default Sans-Seriff font. Any ideas?|||You have to reboot the server after installing a new font.
|||After initially trying to just install the missing font (which did not work), installing the font and then rebooting the server did the trick! Thanks.

Formatting Issue

Hi

I am using Reporting Services 2005. I have deployed my reports on mutiple servers. It works fine. But on a specific server, when I deployed my reports, its formatting disturbed for a specific font. Wherever I have used Font:

Name: "Arial Narrow"

Size: 8pt

Style: Normal

Weight: Bold

Decoration: None

its size changed and disturbed the whole formatting. It is something related to server settings, but I dont know where to change the formatting to solve the issue. I have tried to change the system display resolution, but it didn't worked. I cant re install server as it is client's machine. It has "Microsoft Windows 2003 Server" installed on it. Please help me to solve the problem.

Looking for a quick response.

I have tried to install Arial Narrow Font on the server. It is installed successfully but the problem is still there. Can anyone help me out to solve the problem.

Urgent

|||

try to check ur issue in this file

ReportingServices.css its available in styles folder under reports folder in IIS or check out styles folder in reportserver folder in IIS

|||

Did you find a solution to this problem?

I'm getting the exact same problem, in the exact same scenario: Deploying to a new Windows 2003 server (of which I don't have complete control) with my Arial Narrow 8pt fonts (normal and bold) being rendered incorrectly. One point: initially the server did not have Arial Narrow on it. I added the font and this improved the situation (arial narrow is being used) but it isn't being rendered like arial narrow should be. Lot's of spacing and padding around each letter, which themselves not looking like arial narrow. If I cut and paste the PDF content into another document (word or outlook) the text is pasted as arial narrow perfectly (not looking anything like the text appeared in the problematic PDF).

|||I am having similiar issues. I have complete access to the pc's displaying the reports and the servers running the reports. I am looking to use a font such as Trade Gothic (our company font) and I am trying to get it to render into the PDF. I have installed the font on all machines and servers involved in the report generation and no success to date. I can get it to show up as HTML output, because that is reliant on the machine to support the font, however when I export to a PDF it falls to the default Sans-Seriff font. Any ideas?|||You have to reboot the server after installing a new font.|||After initially trying to just install the missing font (which did not work), installing the font and then rebooting the server did the trick! Thanks.sql