Thanks, this works. I did have to click the "+" icon and add a new namespace to the Explorer, since adding the namespace from InterSystems Server Manager did not pull it into the ObjectScript Explorer. This is kind of an unusual case since I don't necessarily have a project/workspace for the generated class I want to view. If I already had one, then I wouldn't need to use the namespace explorer.
Depending on how specific you need to make your sorting, you can also modify the custom drilldown spec with ORDER functions. If needed, you could change the measure and the direction for each level. For example:
When executing a query, DeepSee will store intermediate and final results in the cache globals. As the engine was trying to create a new session, it looks like it could not access the database in e:\hs-db\tfoms\. Either this database is mounted read only (in this case you will need to create some DeepSee mappings) or the user executing the query does not have r/w permissions on this database.
go to post
Hi Virat,
Here is a good resource for getting started with InterSystems IRIS BI (DeepSee):
https://learning.intersystems.com/course/view.php?id=1793
If you are interested in creating dashboards and exploring your data, IRIS BI is a good choice.
If you are interested in traditional reporting, you may want to consider InterSystems Reports:
https://learning.intersystems.com/course/view.php?id=1444
go to post
Thanks, this is exactly what I was looking for
go to post
Thanks, this works. I did have to click the "+" icon and add a new namespace to the Explorer, since adding the namespace from InterSystems Server Manager did not pull it into the ObjectScript Explorer. This is kind of an unusual case since I don't necessarily have a project/workspace for the generated class I want to view. If I already had one, then I wouldn't need to use the namespace explorer.
go to post
Congratulations, very exciting!
go to post
FYI: this bug has been reported to development
go to post
Depending on how specific you need to make your sorting, you can also modify the custom drilldown spec with ORDER functions. If needed, you could change the measure and the direction for each level. For example:
ORDER([Product].[P1].[Product Category].Members,Measures.[%COUNT],BDESC)
ORDER([Outlet].[H1].[Region].Members,Measures.[%COUNT],BDESC)
ORDER([Channel].[H1].[Channel Name].Members,Measures.[%COUNT],BDESC)
go to post
When executing a query, DeepSee will store intermediate and final results in the cache globals. As the engine was trying to create a new session, it looks like it could not access the database in e:\hs-db\tfoms\. Either this database is mounted read only (in this case you will need to create some DeepSee mappings) or the user executing the query does not have r/w permissions on this database.
go to post
What database is in /hs/nehi/ ? These protect errors suggest the user may not have permissions on this database
go to post
I just tested and it worked OK for me. I used the following:
Class:
CSV:
Import Settings:
go to post
This now works after modifying my objectscript.export "folder" setting. It was previously "src" and is now "".