[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Messages posted by: GK.spw
Forum Index » Profile for GK.spw » Messages posted by GK.spw
Author Message
Hi Mayank ,

1.Yes, You have to create postgresql dataset for that use Eclipse Studio(SpagoBI Plug-In) and there create report(Project) .
Create DB connection with postgresql after that go to dataset section and paste your query.
After this show result to verify it working fine or no.

2. After this create Select option for Birt Report and drag and drop the dataset which you have created .

3. After defining the look and structure if report you can finish ans preview the same on studio before deploy.

Hope this will help you , or you can call in case you have any problem .
Here in my contact number: 8867726104.

Regards,

Govind Kumar
Hi ,
Steps to create OLAP cube:-
1.Create a project in SpagoBI Studio(Plug-in ) for creating OLAP.
2.Create database connection where your DB would be connected.
3.In the project folder go to Business Model section take right click and select create new Model.
4.Give the Model name and processed forward by selecting Schema and all
5.Finally you would get all tables of your database select the fact and dimension table from your database and move it to business model.
6.Take right click on table and make it cube and dimension , fact table will be your cube and other tables can be your dimension tables.
7.After making table cube and dimension , create relationship between cube and dimension by taking right click on table and select option of Edit-> outbound relationship
then create link between fact and dimension table on any key. Repeat the process for all the dimensions.
8. After this create . Go to Dimension->OLAP->Edit Hierarchy then add hierarchy .
9. Finally create modrain template by Go Business_Model->Create-> Modrain template.
10.After creating this open the xml template and change the tag
<Hierarchy hasAll="true" allMemberName="All Event" primaryKey="ID">
haseAll ='' empty by default make it true as above.
11.Save the templates.
12.Deploy the model on server.
13.Deploy the template on server.

Hope this will help you .
In case you have any issue regarding this all above as i explained fell free to call me on : 8867726104.

Regards,

Govind Kumar
Hi isaac,

I read your problem ,
Just follow these steps:-
1.Drop your existing LOV and AD.
2.Create new LOV and check for the output result for LOV.
3.Create AD(Analytical Driver) and use that LOV .
4. In AD select a option from set default value/First value from LOV/Last value from LOV.
5.Give the permission to appropriate user to user that AD.
6.Now save your AD and used in your Documents. It will work. I think in your case your AD could not fetch the LOV values connected to your AD.
Hope it will help you.
Hi isaac,

I read your problem ,
Just follow these steps:-
1.Drop your existing LOV and AD.
2.Create new LOV and check for the output result for LOV.
3.Create AD(Analytical Driver) and use that LOV .
4. In AD select a option from set default value/First value from LOV/Last value from LOV.
5.Give the permission to appropriate user to user that AD.
6.Now save your AD and used in your Documents. It will work. I think in your case your AD could not fetch the LOV values connected to your AD.
Hope it will help you.
Hello Jen,

By reading your error summary , i found that it has some SQL syntax error that prevent you to preview your result, because your SQL query is not correct so it could not create metadata for your result set. So make sure your SQL query is correct and validate it then preview it , You would definitely get result corresponding to your query.

Best Regards,
 
Forum Index » Profile for GK.spw » Messages posted by GK.spw
Go to:   
Powered by JForum 2.1.9 © JForum Team