Data visualizer error

Hello friends.

We try to generate a chart with this options:

Series: Data.

Category: Periods.

Filter: Organisation Units.

Indicators: “Cobertura vacunacion DPT”

Periods: Yearly: “2013”

The Chart works fine with some organisation units, but others show this message: “Dimension ou is present in query without any valid dimension options”.

Over the version 2.12 works fine. Maybe some error in the migration.

We can show the data in the form.

The Dhis version is: 2.13 12929

Thank you very much.

···


Cordialmente,

**Ing. Marko David Garcia M.
**
**Área de Sistemas integrados de Información
Secretaría de Salud Departamental del Cauca
**

Hi Marko,

Open the OU dimension in the chart to check if an orgunit, group or level is chosen. This error usually occurs after saving a chart or table using the orgunit group or level options. It does not persist after you load it again.

Let’s know if this helps.

Cheers

Busoye

···

On 29 Jan 2014, at 14:48, Marko David Garcia markodavidgm@gmail.com wrote:

Hello friends.

We try to generate a chart with this options:

Series: Data.

Category: Periods.

Filter: Organisation Units.

Indicators: “Cobertura vacunacion DPT”

Periods: Yearly: “2013”

The Chart works fine with some organisation units, but others show this message: “Dimension ou is present in query without any valid dimension options”.

Over the version 2.12 works fine. Maybe some error in the migration.

We can show the data in the form.

The Dhis version is: 2.13 12929

Thank you very much.


Cordialmente,

**Ing. Marko David Garcia M.
**
**Área de Sistemas integrados de Información
Secretaría de Salud Departamental del Cauca
**


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

Hi Marko,

the problem is very likely that the uid of your org unit is starting with a number. Uids must start with a letter, and your uid is likely generated externally. You can check this by using chrome browser and

  • click F12

  • go to network

  • run your visualizer chart

  • have a look in the analytics query going to the server, in the url after the ou= part

You can also paste that url here so we can have a look.

regards,

Lars

Hi Lars.

Some organization don’t start with number.

Attached the print screen file.

Thank you very much.

···

2014-01-29 Lars Helge Øverland larshelge@gmail.com:

Hi Marko,

the problem is very likely that the uid of your org unit is starting with a number. Uids must start with a letter, and your uid is likely generated externally. You can check this by using chrome browser and

  • click F12
  • go to network
  • run your visualizer chart
  • have a look in the analytics query going to the server, in the url after the ou= part

You can also paste that url here so we can have a look.

regards,

Lars


Cordialmente,

Ing. Marko David Garcia M.
**Área de Sistemas integrados de Información

Secretaría de Salud Departamental del Cauca
**

Hi Marko,

thanks for the screenshot. If you look closely there is a dollar sign $ in the org unit uid.

The requirements for uids are:

  • exactly 11 characters

  • numbers and upper/lowercase letters (no special characters)

  • starting with letter

So likely these uids have been generated externally. The reasons why we are a bit strict on this issue is that we want to keep the uids as valid database column names and especially valid XML element names / JSON attributes in order to be better positioned for future development of exchange formats.

regards,

Lars

···

On Thu, Jan 30, 2014 at 7:37 PM, Marko David Garcia markodavidgm@gmail.com wrote:

Hi Lars.

Some organization don’t start with number.

Attached the print screen file.

Thank you very much.

2014-01-29 Lars Helge Øverland larshelge@gmail.com:

Hi Marko,

the problem is very likely that the uid of your org unit is starting with a number. Uids must start with a letter, and your uid is likely generated externally. You can check this by using chrome browser and

  • click F12
  • go to network
  • run your visualizer chart
  • have a look in the analytics query going to the server, in the url after the ou= part

You can also paste that url here so we can have a look.

regards,

Lars


Cordialmente,

Ing. Marko David Garcia M.
**Área de Sistemas integrados de Información

Secretaría de Salud Departamental del Cauca
**

I also want to point out that you can use the web-api to generate UIDs if you need them:
http:///api/system/id?n=10

Example:

http://apps.dhis2.org/dev/api/system/id?n=10

(generates 10 uids)

···


Morten

On Fri, Jan 31, 2014 at 3:07 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Marko,

thanks for the screenshot. If you look closely there is a dollar sign $ in the org unit uid.

The requirements for uids are:

  • exactly 11 characters
  • numbers and upper/lowercase letters (no special characters)
  • starting with letter

So likely these uids have been generated externally. The reasons why we are a bit strict on this issue is that we want to keep the uids as valid database column names and especially valid XML element names / JSON attributes in order to be better positioned for future development of exchange formats.

regards,

Lars


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Thu, Jan 30, 2014 at 7:37 PM, Marko David Garcia markodavidgm@gmail.com wrote:

Hi Lars.

Some organization don’t start with number.

Attached the print screen file.

Thank you very much.

2014-01-29 Lars Helge Øverland larshelge@gmail.com:

Hi Marko,

the problem is very likely that the uid of your org unit is starting with a number. Uids must start with a letter, and your uid is likely generated externally. You can check this by using chrome browser and

  • click F12
  • go to network
  • run your visualizer chart
  • have a look in the analytics query going to the server, in the url after the ou= part

You can also paste that url here so we can have a look.

regards,

Lars


Cordialmente,

Ing. Marko David Garcia M.
**Área de Sistemas integrados de Información

Secretaría de Salud Departamental del Cauca
**

Thank you Lars.

That was the problem.

Thank you very much.

Best regards.

···

2014-01-29 9:13 GMT-05:00 Lars Helge Øverland larshelge@gmail.com:

Hi Marko,

the problem is very likely that the uid of your org unit is starting with a number. Uids must start with a letter, and your uid is likely generated externally. You can check this by using chrome browser and

  • click F12
  • go to network
  • run your visualizer chart
  • have a look in the analytics query going to the server, in the url after the ou= part

You can also paste that url here so we can have a look.

regards,

Lars


Cordialmente,

Ing. Marko David Garcia M.
**Área de Sistemas integrados de Información

Secretaría de Salud Departamental del Cauca
**